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

[Guest]

Actually i don't know how to set up a mail merge using my database?????

 

[Keith]

Actually i don't know how to set up a mail merge using my database?????

Have you tried the on-line help?

www.keithwilby.com

 

[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

 

[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