Mail Merge with Access

[Guest]

I have a table in Access (2003) with Name, Address, City, State, Zip &
Salutation. I also have a letter that I created in Word (2003). I want to
Mail Merge the fields into the letter. Would someone please help me with
this process? When doing something like this, is it better to create the
letter in Word or should it have been created in Access?

Thank you, Karen

 

[John Nurick]

Hi Karen,

For an ordinary mailmerge (one letter to each person): In Word, just go
to the Tools menu, select Letters & Mailings, and then Mail Merge...
This brings up a task pane that takes you through the steps of
connecting the letter to a data source (i.e. your table in your
database) and inserting mergefields which get the data from the Access
fields.

If you just want to do one letter at a time, Albert Kallal's sample
mailmerge application should help you get started:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html