how do i set up a mail merge using data from database

G

Guest

In Access a mail merge is kinda similar to word. You need to create a table
with the columns of data you want to merge, add an auto number column. Then
create a report using the merge table as the record source. Type in the
fixed portion of the mail and put the variable where you want them in the
letter. In the sorting and grouping put a page header on the autonum and a
page break in the autonum page break. This will create a seperate page of
output per row of merge data like in word.
bcp
 
J

John Nurick

These links will get you started:

Albert Kallal's sample mailmerge application:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Q209976 ACC2000: Using Automation to Run Word Mail Merge from Access
http://support.microsoft.com/?kbid=209976

Q209882 ACC2000: Using Automation to Create a Word 2000 Merge Document
http://support.microsoft.com/?kbid=209882

http://word.mvps.org/faqs/MailMerge/index.htm

http://word.mvps.org/faqs/interdev/GetDataFromDB.htm

Q209612 ACC2000: Importing Word Merge Data Files into Microsoft Access
http://support.microsoft.com/?kbid=209612

Q209212 ACC2000: Using Data from Access in a WordPerfect Mail Merge
http://support.microsoft.com/?kbid=209212Q209212
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top