O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required