February 10, 2009

Three handy ways to customize Outlook

  • Date: October 2nd, 2008
  • Author: Susan Harkins

Tweak your Outlook menus and toolbars so that it’s easy to access just the tools you need.


#1: Rearrange existing commands

Most of us use a few commands a lot, and seldom, if ever, use the rest. You can rearrange the commands on a menu or toolbar, making selection a bit more efficient. To do so, choose Tools | Customize, click the Commands tab, and click Rearrange Commands. In the Rearrange Commands dialog box (Figure A), select either the Menu Bar or Toolbar option. Then, choose the appropriate menu or toolbar from the drop-down list at the top of the dialog box. The Controls list box will display the commands, including submenus, as they appear from top to bottom on the menu (or left to right on the selected toolbar).

Figure A

customize outlook

You can add, delete, or move a command up or down (or left and right). Clicking Add will position the new item above or to the left of the selected command. You can also modify the selection by changing its caption and other attributes. Select Begin A Group if you want to add a separator above or beside the selected command. Clicking Reset removes all the customization, in case you need to start over.

#2: Move commands the easy way

You don’t have to use the Customize dialog box to move commands on a toolbar. Hold down the Alt key, click on a button, and drag it to an alternate position or off the toolbar completely. To restore the tool, reset the toolbar or use the Customize dialog box to put it back.

If you remove a custom command, you’ll have to rebuild it if you ever need it again. Consider moving custom commands to a custom toolbar created for the purpose of storing custom commands you think you no longer need. Someday, you may want that command and you can simply restore it from the custom toolbar instead of rebuilding it.

#3: Create custom toolbars

To create a custom toolbar, choose Customize | Tools. Everything you need is right there in the Customize dialog box. Click the Toolbars tab and then click New. In cialis erectile dysfunction the New Toolbar dialog box (Figure B), enter a name and click OK. Outlook will create a new, empty toolbar. Just switch to the Commands tab to add built-in commands to the new toolbar by dragging them from the Commands list.

Figure B

new toolbar

Permalink • Print • Comment

Easy tricks to make your Access forms run faster

  • Date: October 2nd, 2008
  • Author: Mary Ann Richardson

By giving a form less data to digest, you can make it run more efficiently. These two tips can help.


The less data Access has to load into memory when you open a form, the better the performance. For example, if a form will be used solely for entering data rather than for data searches, you should change the form’s data entry property so a blank record opens directly. Otherwise, Access will read in all the records in the file before it displays the blank record at the end of the record set. Follow these steps to change the form’s data entry property:

 

  1. Open the form in Design View and click the Selector button.
  2. In the form’s property sheet, click the Data tab.
  3. Click in the DataEntry property text box and select Yes.

Another way you can improve performance is to use only default formatting cialis en francais and properties for most or all of the form controls. Your form will load faster because Access does not have to load the non-default form and control properties. If you must change the defaults for most of the controls in your form, create one control with the desired properties and make that the default control. To do so, follow these steps:

  1. Add a control to your form and change its defaults according to your form’s requirements.
  2. With the control selected, go to Format | Set Control Defaults.

Now, when you add the control to your form, it will have the same properties as the first one. Access saves only the properties of the default control; it does not need to store each control’s individual properties.

Permalink • Print • Comment

February 9, 2009

10 ways to get more mileage from your Office hyperlinks

  • Date: September 29th, 2008
  • Author: Susan Harkins

Hyperlinks are now a standard fixture in Office documents, but many users don’t know much beyond how to click on them. Susan Harkins has rounded up an assortment of tweaks for fine-tuning the behavior of hyperlinks and using them for specialized tasks.


Hyperlinks reduce the task of retrieving data to a quick click. As a side benefit, they reduce typos and other mistakes you might make if you had to do the work of a hyperlink manually. For the most part, inserting a hyperlink is easy work. But you might not be using them to their (or your) best advantage. There’s more to hyperlinks than a little formatting and quick access. Here are a few tricks you can use to make the most of the hyperlink functionality in Office.

Note: This information is also available as a PDF download.

#1: Control how Word follows a hyperlink

At the settings level, there are two ways to control how to follow a link. By default, when you hover the mouse over a hyperlink, the application displays a ScreenTip with the link’s address and instructions to hold down Ctrl while clicking the link. Alternately, you can right-click the link and choose Open Hyperlink from the resulting context menu. Since most of us are use to a single click, you might find this configuration annoying. Fortunately, you can change it:

  1. Choose Options from the Tools menu and click the Edit tab. Office 2007 users should click the Office button and then click Word Options (at the bottom right).
  2. Click Advanced. In Office 2007, select Advanced in the left pane.
  3. For all versions, check or uncheck the Use Ctrl + Click To Follow Hyperlink option, accordingly, in the Editing Options section.
  4. With this option deselected, the application displays the white hand pointer. A single click is all that’s required to follow the link. Either way, you decide.

#2: Add a custom ScreenTip

The hyperlink ScreenTip lets you check the link’s address before clicking, which is the smart thing to do. Don’t let hyperlinks take you anywhere you shouldn’t or don’t want to go.

If necessary, you can usurp the default message to display a custom message, as follows:

  1. Position the cursor anywhere inside the link, right-click, and choose Edit Hyperlink from the context menu. Or just click Insert Hyperlink on the Standard toolbar. Office 2007 users will find Hyperlink in the Links group on the Insert tab.
  2. In the Edit Hyperlink dialog box, click the ScreenTip button.
  3. Enter the custom text you want to use as the hyperlink’s ScreenTip, as shown in Figure A.

screen tip

Figure A: Enter a custom ScreenTip.

  1. Click OK.

Hovering over the link will display your custom message, as shown in Figure B, instead of the default.

custom screen tip

Figure B: Instead of displaying the link’s path, you can display a custom message.

#3: Link to a specific Excel sheet or cell

Creating a hyperlink to an Excel workbook is easy enough. You click the Insert Hyperlink tool on the Standard toolbar, use the Look In control to locate the workbook you want to link to, enter the display text, and press OK.

However, there’s no simple point-and-click method to specify a specific sheet, cell, or named range in a workbook. Fortunately, that doesn’t mean you can’t do it. To open an Excel workbook to a specific sheet, cell, or named range, add the information to the address in the following form, respectively:

workbook.xls#’sheetname

workbook.xls#’sheetname‘!cell

workbook.xls#namedrange

#4: Fix Outlook hyperlinks that don’t work

Occasionally, the links in Outlook or Outlook Express stop working. They’re not broken, they just don’t work. There are a number of reasons this might happen. If you’re lucky, your popup manager is the problem. Before you spend a lot of time troubleshooting, hold down Ctrl and click the link. If it works, great; if not, trudge on.

Next, check the default browser setting. If you’re using Internet Explorer, choose Internet Options from the Tools menu and click the Programs tab. Check the Tell Me If Internet Explorer is Not The Default Web Browser option. Firefox and other browsers have a similar setting.

If you’ve recently switched browsers, your system could be confused. Check your folder options and reset the browser, as follows (in Windows XP):

  1. From the Start menu, choose Control Panel.
  2. Open the Folder Options settings and click the File Types tab.
  3. Select (NONE) URL: HyperText Transfer Protocol from the Registered File Types list.
  4. Click Advanced. Then, click Edit in the resulting dialog box.
  5. Check the Application control. It should contain a reference to your browser. For instance, Figure C lists Internet Explorer, IExplorer, as the current system’s browser. Change the application if necessary by clicking Browse and locating the appropriate browser .exe file.

browser settings

Figure C: Change the system browser.

The final problem may be a missing registry key or value. If that’s the case, the fix is usually simple. From the Start menu, choose Run and then enter

regsvr32 urlmon.dll

Click OK and then clear the resulting confirmation message. If that doesn’t fix the problem, run the following commands from Run:

Shdocvw.dll Msjava.dll Actxprxy.dll Oleaut32.dll Mshtml.dll Browseui.dll Shell32.dll

#5: Avoid hyperlink text missteps

Hyperlinks have been around a while and most users are familiar with them. Effective links use meaningful text that describes the link’s purpose or target. Readers should know why they’re clicking and where they’re going when they do. Here are a few hyperlink text don’ts:

  • Don’t use the hyperlink text “Click Here.” Your users don’t need a map to use links. In fact, you might find that people skim right over “Click Here” links.
  • Don’t hyperlink several sentences or an entire paragraph.
  • Don’t hyperlink verbs.
  • Don’t issue commands. (”Click Here” is a command.)

For instance, “More information on creating good hyperlinks is available” is much better than Click here for more information on creating good hyperlinks or More information on creating good hyperlinks is available. The first example is succinct and clear.

#6: Hyperlink to open a new document

Opening a new document is simple enough, but you can make the task even easier with a hyperlink:

  1. Choose Hyperlink from the Insert menu or click Insert Hyperlink on the Standard menu. Office 2007 users will find Hyperlink in the Links group on the Insert tab.
  2. Click Create New Document.
  3. Enter a name for the new document, worksheet, or presentation.
  4. Check one of the edit options.
  5. Click OK.
  6. Click the hyperlink to open a new document.

You might add this type of hyperlink to a custom template or a document that doesn’t display the standard menus and tools. Users who are unfamiliar with the application will also find this hyperlink useful.

#7: Move and hyperlink at the same time

You can both move and define text as a hyperlink with one purposeful effort. Simply select the text and right-click it. (In Excel, right-click a cell border.) Then, drag the text to a new location and release the mouse button. When you do, the application will display the menu shown in Figure D. Choose Create Hyperlink Here. To edit the new hyperlink, right-click it and choose Edit Hyperlink.

document hyperlink

Figure D: Right-click to move and define text as a hyperlink.

#8: Stop hyperlink hijacks

If your browser is open when you click a hyperlink in another application, Windows sometimes dumps the current page and opens the hyperlinked page. You can click Back or you can alter Internet Explorer’s behavior — this is really an IE problem and not a hyperlink problem. If you want Internet Explorer to open hyperlinks in a new window, reset the Reuse Windows For Launching Shortcut setting as follows:

  1. Choose cialis dosages Internet Options from the Tools menu.
  2. Click the Advanced tab.
  3. In the Browsing section, uncheck the Reuse Windows For Launching Shortcut (When Tabbed Browsing is Off) option.
  4. Click OK.

#9: Control the link instead of browser settings

You can’t always control the browser, but you can force the issue by including appropriate instructions in the link itself. Doing so takes a bit of work, but it’s worth it if you need the control. To enter a hyperlink that opens in a new window, do the following:

  1. Enter this field code:
    HYPERLINK “http://URL“no
  2. Highlight the entire field code.
  3. Press Ctrl + 9.
  4. Click inside the code.
  5. Press F9.

Now the code appears as a traditional hyperlink with a custom ScreenTip, as shown in Figure E.

hyperlinking

Figure E: Force the default browser to open a link in a new window.

#10: Stop address formatting

By default, Office applications format a URL or e-mail address as a hyperlink. This setting is helpful to most users. This setting can be annoying if you don’t want the address formatted. To undo the format, you can press backspace or Ctrl + Z. If you unformat links most of the time, disable the setting as follows:

  1. Select AutoCorrect from the Tools menu. If you’re using Office 2007, click the Office button and then click application Options (at the bottom right). Select Proofing in the left pane and then click AutoCorrect Options in the AutoCorrect Options section.
  2. Click the AutoFormat As You Type tab.
  3. Uncheck the Internet and Paths With Hyperlinks option in the Replace section.
  4. Click OK.

This is an all or nothing feature, though. If you disable it, you’ll have to format hyperlinks manually.

#11: Automate e-mail responses

Clicking an e-mail address hyperlink opens the default e-mail client and fills in the address. You can also fill in the subject and even the body of the message from the hyperlink using a few HTML tricks. Doing so is helpful when you want to control responses. The form you’re used to is a simple e-mail address:

address@domain.com

To control the subject text, use the following form:

address@domain.com?Subject=subjecttext

Enter message text using this form:

address@domain.com?Subject=subjecttext&Body=bodytext

Unfortunately, you can’t reliably use space characters. Replace all space characters with %20. If you don’t, the link stops at the first space character.

The following hyperlink, when clicked, displays the window shown in Figure F:

ssharkins@gmail.com?Subject=Hyperlink%20Article&Body=I%20loved%20your%20TechRepublic%20article%20on%20hyperlinks

mail to

Figure F: The hyperlink filled in the address, the subject, and entered a short message.

#12: View Outlook contacts

You can use a hyperlink to quickly display contact information in Outlook from other applications. For example, the following form opens contactname in Outlook contact’s window:

Outlook:\\Personal%20Folders\Contacts\~contactname

For more codes, search Outlook’s Help on “Types of Hyperlinks.”

#13: Quick hyperlink toolbars in Outlook

Outlook has a neat hyperlink trick — you can hyperlink any file, application, Web page, or e-mail address from the toolbar. To add a hyperlink toolbar button, do the following:

  1. From the Tools menu, choose Customize and click the Commands tab.
  2. Drag any button (not menus) to the toolbar.
  3. Right-click the button, choose Assign Hyperlink, and then select Open.
  4. Enter the path to the hyperlink’s destination and any other hyperlink properties you like.
  5. Click OK and then close the Customize dialog box.

Generally, you’ll want to use a button image that represents the hyperlink’s task. If there’s no image, use a ScreenTip or the button’s Name property to display meaningful text.

Permalink • Print • Comment

Remove and Copy Toolbar Buttons

Are you an MS Office user who likes to customize your workspace?

Specifically, do you do a lot of toolbar customizing?

(Obviously, most of the 2007 programs don't have toolbars, so this doesn't apply to those. However, Outlook and Publisher 2007 still use the old menu and toolbar system and it does work for them).

Here are a couple of quick tricks for you. These are anytime customizations that may help you along your way.

  • To cialis da 5 mg copy a toolbar button, press Ctrl + Alt while dragging the button to a new location.

  • To remove a toolbar button, press the Alt key while dragging the button into the document. When you release the mouse button, you'll find that it disappears. (A great way to make extra space is by getting rid of the things you just don't use).

Yep, that's right. Experienced toolbar customizers are used to opening the Customize window to accomplish that stuff, but it's not needed for these tricks.

Just a couple extra tips for making your work environment all yours!

Permalink • Print • Comment

February 5, 2009

Microsoft offers to just ‘Fix it’

When people encounter a problem with their PC, they often go to the Web and do a search to see if others have had the problem. If they are lucky, someone has found a fix and listed the steps on either a support document or within a user forum.

 

Now, they may have an even better option.

 

Over the past six weeks, Microsoft has quietly added a “Fix it” button to a few of the thousands of help documents on its Web site. When clicked, the computer then takes all the recommended steps automatically.

 

An example of the “Fix it” button that has started showing up in some Microsoft help documents, offering users a one-click solution.

 

“If we know what those 15 steps are why shouldn’t we just script it,” said Lori Brownell, Microsoft’s general manager of product quality and online support

The “Fix it” option is still fairly rare, showing up in around 100 different help documents. The effort is growing rapidly, though, up from just four such fixes when the program quietly began in December.

 

Microsoft continues to offer users the option of doing things on their own cialis cheapest if they either don’t trust Microsoft or just like being in control.

“We’re not trying to hide anything,” she said.

 

The first fixes included a number of common issues, including restoring a missing Internet Explorer icon to the desktop, how to enable the DVD library in Vista’s

Windows Media Center as well as what to do when encountering the error message in Street & Trips 2008 that “Construction information for routes could not be downloaded”

 

For now, Microsoft is having to go back and search its archives to see which of its problem solving tips can be automated. Eventually, it hopes to create the automated fixes at the same time the help articles are created.

 

Where it can, Microsoft is also adding the “Fix it” option into the error reporting tool built into Windows. Initially, all users could do when a program crashed was send a report to Microsoft. More recently, the system has started checking to see if there is any information on the issue. Next up, said Brownell, is offering the option to have the issue solved automatically.

 

Long term, the company has even broader hopes.

 

While it would like to just eliminate bugs and glitches, Brownell said that is not an attainable goal.

 

“We’d love for our customers to never have problems,” she said. “We’ll never ship bug-free software as hard as we try.”

Instead, she said she is aiming for a day when Microsoft’s products themselves will be able to spot problems and proactively offer fixes. As an example, she noted that in Exchange, it’s a pretty safe bet that once one gets low on disk space, bad things will happen. Making sure that users take action before problems occur is an example where the company is headed.

 

Another example, she said, would be for Microsoft to be able to notify users if they are running two drivers that others have found to conflict with one another. Assuming the appropriate privacy safeguards were in place, Brownell said it would be great for the user to be alerted and offered a fix before a problem occurred.

That proactive world is still largely a vision rather than a reality. That said, Brownell said that the company is putting in place some of the plumbing necessary to make such things possible.

 

With Windows 7, Microsoft has added an “action center” that Brownell said offers the underlying capability needed to serve up fixes within the operating system. She said that she would expect some opportunities for that over the life of the product, though the current beta version of Windows 7 has few examples of that.

Personally, I’d just like to see the “Fix it” button extended to other areas of my life. I’d really like one that would make travel plans, fill out my expense reports and

hire a plumber. That would make me (and my partner) much happier.

 

For what would you like to see a “fix it” button?

Permalink • Print • Comment
« Previous PageNext Page »
Made with WordPress and the Semiologic theme and CMS • Sky Gold skin by Denis de Bernardy