Mailing List/Letter Merge in Mac Office '04

[TheJayWay]

Hey Guys and Gals,

I'm trying to figure out how to take data from a excel spreadsheet and plug it into a letter so that the address changes to match that of the recipient as well as the Dear XXX space.

Anybody ever done this? I'm flummoxed and have not a clue.

Any help would be great!

Thanks!

 

[iSaint]

Tools > Data Merge Manager

One of my favorite features.

Make sure you have the data on the spreadsheet broken up into the fields you wish to enter. i.e. Name; Address; City; State; Zip, etc.

Once you start the Merge tool, a Merge Pallete will appear, just as the formatting pallete does on the right of the screen. You will need to select the file name that is the spreadsheet for the source data. You can then drag and drop field names into the Word document. It's really much easier on a Mac than a PC.

Use your Help function if I'm not clear, or if you get lost.