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 ...