Using Excel to Supply Mail-Merge Data to Word

Microsoft Word includes a Mail Merge command that facilitates the batch creation of letters, e-mail messages, envelopes, mailing labels, and directories. You can use Excel tables (as well as many other types of data source) to supply names, addresses, phone numbers, and so on, for use by this command.

Before you feed data from Excel into Word's Mail Merge Wizard, 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, Address1, Address2, and so on.

  • Each field name should be unique.

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

Get Microsoft® Office Excel 2003 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.