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 2010: 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 incredibly powerful and yet simple to use when you want to enter, sort, filter and analyze data. Let's see how we can use Microsoft Excel as a data source for our mail merge. We have our letter open, with the text that will be variable text highlighted. Let's go ahead and open an Excel workbook. We will go to Select Recipients > Use Existing List, and I am going to go open my Exercises folder in Chapter 1 and select the Vendors Workbook.

When I open the workbook, there are two different tables listed, but these aren't really tables; they are worksheets. I know they are worksheets, because they have a dollar sign at the end of their name, and it says that the first row of data contains column headers for both of these. There are some column headers, so that's great. Now, I am going to open up this first data set, which is called Current. When I click on Edit Recipient List,...

Using Mail Merge with an Excel table
Video duration: 7m 12s 1h 31m 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 2010: Mail Merge in Depth

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