November 9, 2008

Quick Office toolbar trick

  • Date: August 23rd, 2008
  • Author: Susan Harkins

We all have tools that we use more than others, and if you’re like me, you appreciate having them when you need them — not necessarily when Word thinks you need them. In other words, I’ve moved and/or copied some tools from one toolbar to another, which isn’t as difficult as you might think.

You can customize toolbars by right-clicking a toolbar and choosing Customize to open the Customize dialog box, which contains cialis cheap online many neat tricks. If you just want to move or copy a tool from one toolbar to another, you don’t need the Customize dialog box at all:

  • To move a tool from one toolbar to another, hold down the [Alt] key and move the tool.
  • If you want to copy the tool (so that it’s available on both toolbars), hold down both the [Ctrl] and [Alt] keys while you drag the tool.

Of course, both toolbars must be visible for this shortcut to work.

This shortcut doesn’t work with 2007’s new Ribbon.

Permalink • Print • Comment

Create a watermark using a Clip Art Gallery image

  • Date: May 27th, 2008
  • Author: Mary Ann Richardson

While you can use Word’s Printed Watermark dialog box to add a custom watermark to your document, Word also lets you create a watermark from any graphic object (SmartArt, charts, shapes, clip art, etc.) by simply copying the graphic into the Header window. Follow these steps to create a watermark from a copy of a picture taken from the Clip Art Gallery:

  1. Open a blank document.
  2. Go to Insert |Clip Art. (In Word 2007, click the Insert tab and select Clip Art in the Illustrations group.)
  3. Search for the desired clip art in the Clip Art task pane.
  4. Go to View | Header or footer. (In 2007, double-click the top of the page to access the Header area.)
  5. Click inside the Header window.
  6. In the Clip Art task pane, double-click the clip art picture you want as your watermark.
  7. Right click the portion of the picture in the header window and select Text Wrapping.

  1. Click the Behind Text option.
  2. Right-click the portion of the picture in the Header window and then select Send To Back.
  3. Click Send Behind Text.
  4. Click and drag the bottom-right picture handle to extend the cialis canadian pharmacy picture into the middle of the document beyond the header.

You can also format the picture to make it more transparent. For example, in Word 2007, follow these steps:

  1. Double-click the Header to display the Header window.
  2. Right-click the picture in the Header window and then select Format Picture.
  3. Click the drop-down arrow of the Recolor button and click the first selection under Light variations. (Alternatively, you can choose Washout under Color Modes.)
  4. Click Close.

Permalink • Print • Comment

A bit of discipline can reduce Inbox clutter and keep it clean

  • Date: March 17th, 2008
  • Author: Susan Harkins

Lots of mail in your Inbox doesn’t mean you’re popular. It means you’re unorganized. It might even get you into trouble. Messages in a cluttered Inbox tend to fall off the screen and into a black hole.

The truth is that most of us use our Inbox as a storage bin and that’s a bad idea. An Inbox full of mail is oppressive. Trying to manage all that mail is like cleaning your garage-it’s hard work that you avoid at all cost. The more you avoid it, the bigger the mess grows.

The hardest part is making all those decisions. Each E-mail requires your attention:

  • Respond to it and delete it (when you’re lucky).
  • Keep it to act on later.
  • Keep it for future reference.

Now, you may have a broader list of possibilities, but that doesn’t matter. What matters is that you have to make a decision for every message you receive. Managing E-mail is a three-layer line of defense:

  • Delete the old.
  • Divide (and conquer) what you must keep.
  • Let Outlook manage incoming mail.

The first step is the hardest but you must get rid of all those old messages. Create a personal folder and name it Old Stuff or something just as appropriate. Then, sort the messages in your Inbox by the Receive column. Move everything that’s older than a month (or a week if you’re really drowning) to the Old Stuff folder.The next step is to find some commonality among the messages that are left. For instance, you might receive a lot of mail from family and friends or you might have several messages regarding ongoing projects. Create personal folders to accommodate these categories. It doesn’t matter if you get it exactly right the first time. Just start. Later, you can combine folders or add more.

Once you have all the folders you need, drag messages from the Inbox into their respective folders. Next, create rules to download subsequent messages directly into these folders-bypassing the Inbox altogether.
Congratulations, you’ve seriously reduced the messages in your Inbox. Even better, you’ve reduced the number of subsequent messages that will ever see your Inbox.

All that should be left in your Inbox at this point is miscellaneous items. Go ahead and deal with them now. The goal is to empty your Inbox. If you find something you can’t delete, find a folder for it.

Now, you can’t just forget about all those moved messages. Go through the folders and continue to delete as much as you can. Use flags to identify, in some meaningful way, what’s left. It might cialis c20 take you a few days to come up with just the right flag system.

Once all your mail is in a folder and flagged, settle on a routine for checking new mail. Everything in your Inbox should be deleted or moved to an appropriate folder. All new messages in personal folders should be deleted or flagged.

By combining flags and search folders you can easily manage the E-mail you must keep. For instance, you might have many folders for current projects, but using just one  search folder you can view all messages flagged for an immediate response. You don’t have to sort through every folder. Just view the appropriate search folder.

Keeping the Inbox empty will be easier, but don’t expect miracles. Adjust rules or add new ones as necessary. The idea is to let Outlook filter messages into folders, bypassing the Inbox completely.

It will still take some effort on your part to keep things manageable:

  • Quickly pursue new E-mails in the Inbox by deleting them, or moving them and flagging them.
  • Check new messages in personal folders and delete them or flag them.
  • Use search folders to manage flagged messages.

Don’t forget about the Old Stuff folder. It might take you several days to get through all that old mail, but none of it’s going anywhere. Chances are you’ll delete most of it. When you find a message you need to keep, drag it to a folder, flag it, and use a search folder to manage it.

Permalink • Print • Comment

Use a single mailing list to send out two entirely different letters

  • Date: August 26th, 2008
  • Author: Mary Ann Richardson

Thanks to Word’s mail merge fields, you can automate the process of producing different letters based on criteria you specify. This example shows how it works.


When you need to send two or more different letters to your clients based on a value in a field in the client database, you don’t need to compile two separate mailing lists. Using the If… Then…Else rule with the INCLUDETEXT field, you can process both letters at once. For example, say you have saved two documents, one containing the body of the letter for clients located in Missouri and a second containing the body of the letter for clients located in Illinois. To create one mailing that will send the appropriate letter to each client, follow these steps:

  1. Open your mail merge document, which contains the merge fields and text common to both letters.
  1. Click below the greeting, where you want to insert the body of your letter.
  1. Click the drop-down arrow of the Insert Word Field button in the Mail Merge toolbar. (In Word 2007, click Rules in the Write & Insert Fields group of the Mailings tab.)
  1. Click If…Then…Else.
  1. Click the Field Name box drop-down arrow and select State (Figure A).

Figure A

  1. Click in the Comparison box and select Equal To.
  1. Click in the Compare To box and type MO.
  1. Click in the Insert This Text box and type This is the text for MO.
  1. In the Otherwise Insert This Text box, type This is the text for IL.
  1. Click OK.
  1. Right-click the field in the document and select Toggle Field Codes to display all the field codes (Figure B).

Figure B

  1. Select the following text inside the quotes: This is the text for MO. (Do not select the quotes.)
  1. Go to Insert | Field. (In Word 2007, click Quick Parts in the Text Group of the Insert tab.)
  1. Click Field.
  1. Under Field Names, select IncludeText (Figure C).

Figure C

  1. Click in the Filename Or URL box and type the full pathname for the file containing the body of the letter for Missouri clients.
  1. Click OK.
  1. Right-click the field and select Toggle Field Codes.
  1. Select the following text inside the quotes: This is the text for IL. (Again, do not select the quotes.)
  1. Repeat steps 13 through 15.
  1. Click in the Filename Or URL box and type the full pathname for the file containing the body of the letter for the Illinois clients.
  1. Click OK.

When you right-click the field and toggle the field codes, your rule should look like the one in Figure D, substituting your filenames for each of the letters. When you run the mail merge, Word will print the letter that pertains to the value of the State field in each client record. (If you prefer to enter the field codes entirely from the keyboard, be sure to use Ctrl + F9 to enter the cialis c10 brackets.)

Figure D

Note that you can use the If …Then… Else rule with INCLUDETEXT to print out different letters for any number of values in the field. Simply create a different If…Then…Else rule for each value, with INCLUDETEXT as the first variable and blank (nothing between the quotes) for the second variable.

Permalink • Print • Comment
« Previous Page
Made with WordPress and an easy to customize WordPress theme • Sky Gold skin by Denis de Bernardy