O'Reilly logo

Microsoft® Excel® 2010 Inside Out by Mark Dodge and 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 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 manipulate separately ...

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