Date: October 15th, 2007

Author: Susan Harkins

Have you ever sent an e-mail to the wrong person? If you’re lucky, it didn’t matter. However, it could be an embarrassing and even critical error. For instance, let’s suppose you have two clients named John. You sent John Smith your regular fee schedule. Later, while negotiating a new project with John Smythe, you offer a discount. Oooops! Outlook just sent the discounted fee schedule to John Smith instead of John Smythe, as you intended. Just how did that happen?
It really isn’t Outlook’s fault. Usually, this kind of error occurs when you’re in a hurry or distracted. You type John into the To box, take the first hit, and send — without realizing that Outlook’s AutoComplete feature chose the wrong John. It happens….

There are two ways to complete an e-mail address:

The second method is the one that can get you into trouble. The AutoComplete feature updates its list so fast that it’s easy to select the wrong item. It’s a great feature, but prone to mishaps if you’re not careful. You can disable AutoComplete as follows:

1. In the Mail window, choose Options from the Tools menu.
2. Click E-mail Options.
3. Click Advanced E-mail Options.
4. Uncheck the Suggest Names While Completing To, Cc, And Bcc Fields option.
5. Click OK three times.

The truth is, AutoComplete is helpful and you might not want to disable it. I use it almost exclusively.

Another problem is that Outlook maintains a history of all the addresses you enter, not just the ones you store in the Address book. These names make their way onto the AutoComplete list, even if you don’t want them. Additional names can throw a monkey-wrench into your routine if you don’t expect them. When one of these names shows up, simply delete it before it gets you into trouble.

Finally, the best advice is the least helpful. Try to slow down and pay attention to the AutoComplete viagra mail order list. Okay, I’m obligated to say that, even though I don’t always practice what I preach. Carry on as best you can, forewarned.

Most of you know how to sort e-mail messages in MS Outlook, right? You know, you do it by clicking on the column heading of the field you want to use as the sort criteria.

An up arrow sorts the messages in ascending order and a down arrow sorts in descending order, based on the data in the column you chose.

But have you ever wished there was a way to sort by two criteria instead of just one?

Maybe you receive a lot of messages from the same person and you want them sorted not only by who viagra in the uk sent it, but also by when it was received. That way, you can quickly find the newest message. If you've tried to do that before, you've probably clicked on the From column heading and then clicked on the Received column heading, only to be disappointed that it doesn't allow for a two column sort. Or, does it?!

Actually, Outlook will allow for a multiple column sort if you know about the magic key. (Okay, so it's not magic, but when you get one of these programs to easily cooperate, it sometimes feels that way!)

What you're looking for is the Shift key.

To do a multiple column sort of your messages in Outlook, click first on the column heading of the primary sort criteria. (Double click if you need to switch between ascending and descending).

Now, hold down the Shift key and click on the column heading of your secondary sort criteria. (Clicking multiple times will switch the sort order back and forth).

Voila. You can now sort a little bit of this and a little bit of that with just a little help from the Shift key!

Date: April 22nd, 2008

Author: Susan Harkins

by Scott Lowe MCSE | Apr 05, 2006 7:08:00 PM

Takeaway: For a few simple form letters, Microsoft Word's internal address book may be all you need when using the built-in mail merge features. However, the true power of Word's mail merge is only revealed after you integrate it with the more advanced database features of Microsoft Excel. In this How do I… article Scott Lowe shows you how to integrate Excel data when using Word's mail merge feature.

But, how many of you actually keep all of your contact information in Word? If you keep it in any Office program, you probably keep it in Excel, or in Access. Or, if you keep it in some other system, it's generally an easy process to get, for example, customer address information into Excel. In this article, I will show you how to make use of Excel data when using Word's mail merge feature.

I'm assuming that you know how to enter data into Excel and understand the purpose of Word's mail merge feature. If you need a refresher on either of these topics, take a look at previous articles in this series. I will be repeating some of the mail merge information from my previous article in this article in the interest of completeness. However, if you're interested in Word mail merge, you should read that article before you read this one.

Inventory sheets

For this article, rather than the typical form letter, we'll use an existing Excel used vehicle inventory to create inventory sheets that can be posted on each vehicle on the lot. Here's a snapshot of the Excel inventory table.

Figure A

We'll use this inventory table for the examples in this article.

Note the column headings in Figure A. Every column has some kind of heading. While this isn't absolutely required, I do highly recommend that you assign a column heading to every column in your spreadsheet. Word will use these column headings as field names. If you fail to provide a column heading, you'll get things like "Column A", "Column B", which can be rather confusing. "Leather seats" and "Sunroof" are much more descriptive.

The Word mail merge process

To get started, open a new document in Word and choose Tools | Letters and Mailings | Mail viagra brand cheap Merge from the menu bar. In the sidebar area, Word opens a Mail Merge helper that provides you with a wizard-like interface that walks you through the process.

Step 1: Select document type

Word's mail merge can be used to create form letters, e-mail messages, envelopes, labels, or directories. With a little imagination, these choices let you create just about any kind of document or communication you would need.

Figure B

Mail merge step 1: Determine your document type

Feel free to experiment with the different document types. For this example, we'll be creating an inventory sheet using Excel data. The best option to choose for this kind of mail merge is Letters, so I'll choose that option from the list of selections. When you've made your selection, click "Next: Starting Document".

Step 2: Select starting document

Any document you've created can be converted into a form letter. Or, if you want to start from scratch, you can use the current document (which, for me, is a blank document) and type your letter. You can also use any document template on your computer, or on Office Online, Microsoft's Web repository that contains hundreds of templates available for download.

This starting document is often referred to as the "master document" as well. The terms are interchangeable, although other Word features also use the term "master document", so be sure to keep things straight.

The starting document is the document that will ultimately contain the base form letter.

I'm going to use the blank document I have on the screen as the starting document.

Figure C

Mail merge step 2: Choose the starting document.

Once you've decided on the document that gets the honor of being the starting document, click the "Next: Select recipients" option. Notice that the wizard also allows you to go back to the previous step if you need to.

In step 4 of the wizard, you will be able to modify your letter.

Step 3: Select recipients

In the previous step, you chose what document to use as a form letter. In this step, you need to decide to which recipients you want to send the form letter. Word's mail merge feature lets you use a wide variety of data sources. In this case, we'll use an existing list. Click the Browse button to look for the Excel file you want to use for your mail merge.

Figure D

Mail merge step 3: Tell Word from where you intend to get your recipients.

The Browse button opens a window called "Select Data Source" from which you can connect Word to just about any database you like. From this window, choose your Excel inventory file and click the Open button.

Figure E

Select your Excel data file and click Open.

Most people are not familiar with "Named Ranges" in Excel (I'll cover them in a future article), so the resulting window might be a little confusing at first since it looks like gibberish. Notice that three of the four choices are the names of the individual sheets (Sheet1, Sheet2 and Sheet3). In my Excel file, the inventory information is on "Sheet1", so I will choose the corresponding option from the Select Table window. Note also the "First row of data contains column headers" option at the bottom of this window. As I mentioned before, it's really a good idea if you include headers in your spreadsheet. However, if you don't want to do so, make sure you uncheck this box. If you don't, Word will assume that the first row of your data contains headings.

Figure F

Select the sheet on which your information resides.

On the resulting window—the Mail Merge Recipients window—are a number of options that let you control what records you want to include in your merge. Note the checkbox to the left of each record. The check in the box indicates that this record will be included in your merge. If you don't want to include a particular record, click the box to remove the checkmark. You can also filter the records that you want to include in the merge by using the down arrows next to each heading. The buttons at the bottom of the window let you find specific records (Find), quickly select and deselect all of the records (Select All, Clear All), make sure that addresses are valid (Validate) and more. Click OK when you're done. Figure G below shows you the Mail Merge Recipients window while Figure H shows you your Word sidebar after you're done deciding which records to import.

Figure G

Which records do you want to include in your mail merge?

Figure H

If you want to make a change to your list, click the "Edit recipient list" option.

Step 4: Write your letter

Ok – this one isn't a letter (it's a form to slap onto the cars in our inventory), but Word doesn't know that. To Word, everything is a letter! On this step, you have the Word sidebar shown below in Figure I.

Figure I

The "More items" link is most appropriate for this example.

On this step, create your inventory sheet/flyer as your normally would. However, instead of typing in the individual inventory information, use fields instead. In this way, you're keeping your letter generic and letting Word do the work. You should also see a new toolbar added to your tool arsenal.

I'm not going to go over every option on the toolbar in this article, but will provide details on which buttons you need for most mail merge operations.

The first three buttons are pretty important. In order from left to right:

• Main document setup: This is the same as step one of the wizard in that you select the type of document you intend to create.
• Open data source: Again, this button loosely matches a step in the wizard; in this case, Step 2. When you click this button, Word opens up a dialog window asking you to choose the data file you want to use. If you want to connect to a different kind of source, such as an Access database, click the New Source button.
• Mail merge recipients: This button opens the window you saw in the previous step where you can decide which recipients should be included in the final output.

Now, we'll on to making the appropriate changes to your letter to make it generic. Notice in the sidebar, now entitled "Write your letter", there are a number of options, including "Greeting line", "Postal bar code", and "More Items…"

Figure J

The mail merge toolbar makes using mail merge a little easier.

Take particular note of the sixth button from the left. I've highlighted it for you in Figure J. Click this button to open the Insert Merge Field window. Alternatively, you can click the "More Items…" option in the sidebar. Either way you do it, Word opens up a window from which you can select fields from Excel to add to your flyer. As you're typing your flyer, use this window to add a field where you would normally put in specific information about a vehicle. For example, rather than typing in the price of a vehicle, insert the "Price" field instead. Figure K shows you what my sample flyer looks like.

Figure K

My sample letter, with merge codes.

Bear in mind that you need to put spaces, commas and tabs where they belong. In the previous article on this topic, we used address fields, but still had to manually put the comma between the city and the state fields.

Click "Next: Preview your letters" when you're done with your flyer.

Step 5: Preview your letters

With your flyer crated, it's time to see the results. From the sidebar, click the "Next: Preview your letters" option. The result should look similar to what you see below in Figure L.

Figure L

Here's a preview of the flyer.

One thing you may notice right away is the formatting of the price is wrong. There is no dollar sign or comma where it belongs. To fix this, click the "Previous: Write your letter" option in the task pane. This will take you back to the "write your letter" step of the wizard.

Figure M

Use the "Previous" option to go back to the previous step.

Now, click somewhere in the Price field and press Alt + F9 on your keyboard, or, right-click the field and choose "Toggle Field Codes". Either way, you will get the result shown below in Figure N.

Figure N

The fields look a little different here. This is what the full field code looks like behind the scenes.

Note, if you use the Alt+F9 option, you will always get the field codes for all of the fields. If you right-click a field and choose Toggle Field Codes, you will get the field codes for just that field. It doesn't hurt to show the field codes, but, as you can probably see, it can muddy up your document.

In these field codes, we want to change the format so that it comes out as currency rather than as a plain number. To do so, we need to type in a little code, such as "{ MERGEFIELD "Price" \# $#,### }" The "\# $#,###" portion of this stuff tells Word that we want to format this field as a number with a dollar sign followed by # signs indicating where numbers from the price will go. Also note the inclusion of the comma. Don't worry that there is only a single # sign between the dollar sign and the comma. Word knows enough to out multiple digits in that space for amounts larger than or equal to $10,000. Look at Figure O. When you're done, click the "Next" option to go to the "Preview Your Letters" step again.

Figure O

The field codes are used to make granular changes to the field.

Now, take a look at Figure P below. This time, the price of the car is properly formatted and will look a lot more professional. Choose the "Next: Complete the merge" option.

Figure P

The result: A properly formatted dollar amount.

Step 6: Complete the merge

This part is easy! Your sidebar again changes to match the step you're on and looks a whole lot like what you see below (Figure Q).

Figure Q

Step 6: Finish your mail merge.

At this point, Word has not officially performed the merge. That is, your letter and data file are still mostly separate. When you click one of the two options—(1) Print; or (2) Edit individual letters—Word asks you what you want to merge.

Figure R

What records do you want to have printed?

Your options here are to merge all of your records, in which case you will get one page per recipient, or choose which records you want to include. When you choose the print option, Word sends your flyer right to your printer. If you made a mistake, you have to reprint the flyers. By choosing the "Edit individual letters" option, you make Word create a huge document that includes every letter just as if you'd typed the letter manually for each recipient. I usually prefer to use the latter option so I don't have to reprint things.

Harness the power

Now, you've seen Word's mail merge in action using its own limited database and with its ability to harness Excel's power. You've also seen two examples of what mail merge can do: create simple letters, or create non-standard documents such as flyers.

Date: April 18th, 2008

Author: Susan Harkins

If your Outlook Task view looks anything like mine, it’s too busy to be truly effective. Fortunately, you can filter the view, but sometimes it’s hard viagra alternatives to get the right result. Most of us always need to know what’s overdue. Sometimes, we need to know what’s due in the near future. More often than not, we want both. When this happens, use multiple criteria to get them.

Knowing how to express what you need can be challenging until you’re familiar with the existing filters. You just have to open the feature and look around. For instance, the following example uses advanced filters that you might not know about. Suppose the current date is April 3, 2008, and the status for five tasks is as follows:

To view a list of only overdue items and those that are due the next week, use advanced filters:

1. Click Customize Current View in the Current View section.
2. Click Filter in the resulting dialog box.
3. Click the Advanced tab in the Filter dialog box.
4. In the Define More Criteria section, open the Field control’s drop-down list and choose Complete from the Frequently Used Fields item.
5. Click Add To List. That’ll take care of outstanding items.
6. Next, choose Due Date from the Frequently Used Fields item.
7. Select On Or Before from the Condition control.
8. In the Value control, enter “7 days from now”.
9. Click Add To List. That’ll take care of items due during the coming week.
10. Click OK twice.

The filtered list, shown below, now contains only three items — one that’s overdue and two that come due during the next week. The list no longer displays the completed item or the seminar that’s almost two weeks away.

In this particular case, you could handle the coming week items by choosing “In The Next 7 Days” from the Condition control. However, I wanted you to see how versatile Outlook can be. Use Value expressions to limit items when no existing condition exists.