Mail Merge using Access then save as PDF

[WebMasterB]

In my organization, we send out letters by the thousands, ususally about 500
at a time, due to the time constraints of the current method.

Currently, we process the database, which places the letter contents in a
table called Archives. Then we open the Merge Template Word document, and
process the mail merge to print each individual letter. Next we have to save
each individual letter as a PDF file (Acrobat 8.2 Installed) for record
keeping and quality assurance. What we'd like to do is find a way that this
can all be done from within Access programmatically.

References:
Database File: Mail Merger.mdb
Data Table in Db: Archives
Word Merge Templete: L123 F1223.doc

Please assist if able.

Thank you in advance.

 

[Rose B]

You can run Mail Merge, and subsequent Save As (publish as a PDF) from within
Access - assuming that you are happy with the content of the mail merge
before running. To get the VB code needed, record a macro from within Word
using the mail merge template that prints the letters and then save as to PDF
(when running the mail merge choose option to create a new document, then
when you save it you will have all of the resulting documents).

Having recorded the macro (be careful where it saves the macro to),
copy/paste that into your Access module. You may need to tweek it a bit, and
then advisable to change to use late binding (search this site to discover
more if not familiar with this).

 

[WebMasterB]

Unfortunately Acrobat 8.2 does not give the file conversion (SaveAs) option.
The only option is to print using the Adobe Distiller. When attempting to
use that option, it saves the mail merge as one complete document (All
letters in one file). For record keeping requirements, we must be able to
retain each individual mailing as a seperate file.

Any ideas?