> 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
BCP - 29 Sep 2005 21:32 GMT
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
> > 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
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
>Actually i don't know how to set up a mail merge using my database?????
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.