Using Excel to Supply Mail-Merge Data to Word

Microsoft Word includes a mail-merge feature that facilitates the batch creation of letters, e-mail messages, envelopes, mailing labels, and directories. You can use Excel ranges (as well as many other types of data sources) to supply names, addresses, phone numbers, and so on, for mail-merge use.

Before you merge data from Excel into the mail-merge feature in Word, be sure your Excel worksheet is well structured for this purpose. Your table should meet the following criteria:

  • Each column in the first row should be a field name, such as Title, Salutation, First Name, Middle Name, Last Name, Address, and so on.

  • Each field name should be unique.

  • Every piece of information that you want to be able to manipulate ...

Get Microsoft® Office Excel® 2007 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.