98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Mail Merge from Access
Mail Merge from Access
Resolved · Low Priority · Version 2003
Fri 13 Apr 2012, 16:53Delegate Charlotte said...
Charlotte has attended:
Access Introduction course
Excel VBA Introduction course
Mail Merge from Access
I am comfortable with creating a full mail merge from access but would like to know how/if its possible to mail merge out into individual documents
Mon 16 Apr 2012, 10:04Trainer Anthony said...
RE: Mail Merge from Access
Hi Charlotte, thanks for your query. There's no one-click function to do this but by using the Master & sub-document feature in Word it is possible to separate the individual documents. Have a look here:
http://homepage.swissonline.ch/cindymeister/mergfaq2.htm #SepFile
Note the code option included in the link which I would definitely use if you're going to attempt the merge more than once. Let me know if you need help getting the code to work. Here are two further links to add-ins which can help automate all this:
http://cybertext.wordpress.com/2009/06/15/word-2003-create-separate-mail-merge-documents/
http://www.gmayor.com/individual_merge_letters.htm
Hope this helps,
Anthony
Mon 23 Apr 2012: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Switchboard StartupAn option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed. |
