Using Mail Merge with an Excel table


show more Using Mail Merge with an Excel table provides you with in-depth training on Business. Taught by Gini Courter as part of the Word 2007: Mail Merge in Depth show less
please wait ...

Using Mail Merge with an Excel table

Most organizations maintain a lot of data in Microsoft Excel and it's easy to see why. Excel is both powerful and simple to use when you want to enter, sort, filter, and analyze data. Let's see how we can use Microsoft Excel data as our data source for a mail merge in Microsoft Word. We are already in our primary document, our Simple Letter, and we have identified it as a letter that we want to do a mail merge with. So we are now ready to select recipients.

On the Mailings tab, choose Select Recipients > Use Existing List. Microsoft Word automatically goes to the location where it always looks initially for files, the All Data Sources folder within your profile folder. My file is saved elsewhere, so I am going to go and find it. I am going to go the Exercise Files folder and go to Chapter 1 and open this Excel workbook called Vendors. The Excel workbook has two tables that Microsoft Word recognizes.

It's actually two worksheets and the reason I know they are worksheets is t...

Using Mail Merge with an Excel table
Video duration: 9m 7s 1h 37m Intermediate

Viewers:

Using Mail Merge with an Excel table provides you with in-depth training on Business. Taught by Gini Courter as part of the Word 2007: Mail Merge in Depth

Subject:
Business
Software:
Word
Author:
please wait ...