Mail Merge with Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top