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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Information

This entry was posted on March 16, 2005 by in Tutorials.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 28 other followers

RSS oldaily

Tweets from Major ID Solutions

%d bloggers like this: