Mailmerge from Outlook

Home Up Search This Site What's New? Audio On CDR Favourites Downloadable files Photo Gallery 2002 Photo Gallery 2003 Photo Gallery 2004/5 Photo Gallery 2006/7 Photo Gallery 2008 UK Photo Gallery Ireland Photo Gallery Cats Photo Gallery 

 

Google
 

 

There is no charge for using any of the material (for personal use) on this web site, but if you wish to make a contribution to the ever growing running costs, any donation would be much appreciated. Click the adjacent button to access PayPal
Mailmerge from Outlook 2000/7
Outlook Data File

Word will work with a variety of merge data formats, but for many users nothing more adventurous than merging from Outlook data will be required. Unfortunately the implementation from within Word 2000 is weak. It's a little better in Word 2002/7, but still does not allow the use of all the available fields, and merging to a selection of records is impractical.

Start in Outlook

Virtually unnoticed in Outlook 2000+ is the facility to mail merge from within that application, and such is the extra power that this provides, that in my opinion this was the best reason for upgrading to Office 2000 from Office 97. This function has been retained in later versions and can be found on the Tools menu of Outlook when in Contacts view.

The menus (Word 2007 on the right) are essentially the same in all versions.

 

Clicking this seemingly inconsequential link reveals a host of options concerned with the selection of records. You also get access to ALL the fields in your Outlook database, including any personal custom fields you may have set up. Thus, for example, the categories field, long included in Outlook, now has some useful function.

Any record or subset of records you can access in Outlook, by means of filters or manual selection, can become the data source for your merge. Thus you can merge to one, several, or all of your records, as required.

Note:

The Mail Merge command is context sensitive and is only available from the Outlook Contacts view.

The above dialog box is repeated for all Outlook versions

Merge in Word

You can choose to start with a pre-prepared merge source document, or you can choose to create a new document. Once you have made that choice, Outlook hands over control to Word whereupon the familiar Word mail merge commands become available and Outlook no longer forms any part of the process.

Note that if you use the merge task pane (rather than the easier to use merge toolbar) then the data file is already selected - see below - do not change the data to 'Select from Outlook contacts'

For more information on merging with Word 2002/7 and the use of the merge toolbar - Word 2000/3 or for Word 2007

Merge to Labels from Outlook

 

The same procedure can be used to merge to labels, but there is an extra stage to the process. From the Outlook merge dialog:

Select mailing labels (as an aside, note here that the dialog describes one type of merge as Catalog, whereas Word 2000/7 call this Directory. This is a throwback to the Word 2000 merge wizard, which is called for the next part of the process). Click OK and you get a help message, which looks like one of the following, depending on whether you are using the help assistant. The help assistant is no longer present in Word 2007, but the mail merge helper is and can be added to the QAT (Quick Access Toolbar).

Select 'Complete Setup' or 'OK'.

 

The merge type is already set at mailing labels. To select the mailing label format click setup, which takes you to the label selection dialog:

The data file is already attached.

So close the dialog to produce a label document. If the label gridlines are not displayed - click table > show gridlines from the Word main menus.

From now on the process is the same as for any other label merge.

If you need help with that, see Mail Merge Labels with Word XP or Mail merge labels with Word 2007