Rose Colored Glasses

Random Thoughts on Instructional Design

Merging Excel Data with a Word Document to Create Mailing Labels

If the data or list of items you want to merge with a Word document already exists in an Excel worksheet, you can use the worksheet as a data source file. By using this feature, you not only avoid the time-consuming task of reentering the data in Word or Access, you also have the advantage of maintaining and updating only a single source file.

To use an Excel spreadsheet as a data source file for merging with a Word document or Access database, you must format it in such a way that the packages can recognize it as a data source file.

Formatting Rules:

  • Row 1 of the spreadsheet must contain field names.
  • Column A must contain data.
  • The first record of information for the first person, place, or thing should appear in row 2 of the spreadsheet.
  • No blank rows should appear in the spreadsheet.
  • No total rows should appear in the spreadsheet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

Information

This entry was posted on March 16, 2005 by in Tutorials.
%d bloggers like this: