Mail merge to individual 1 page pdfs

J

Joe Schmeier

Hi,

I have an Excel workbook with a list in it that I use to create single page
pdfs from Word. My current method is to fire up Word, merge one record at a
time, print the currently merged page to Acrobat Distiller, give it a
filename, go on to the next and next, etc.

Surely there is a way to automate this entire process.

I would use the entire list in Excel and could use one of the existing
fields for the file names so the macro shouldn't be all that difficult.

Do until empty...loop.

I have limited experience with Visual Basic, so please be somewhat detailed.

I currently have Office 2003 and Acrobat 5 installed on my machine.

Thanks...

PS, I've seen some programs that can allegedly take a mass of word files and
convert them all to pdf, so if it's easier to create one page docs with those
unique filenames and do the conversion separately, that would be quite
acceptable.
 
A

ANONYMOUS

How about doing the mail merge in the normal way in word and then using
the print function (File, Print) to print it using Adobe Acrobat
Professional? This would be the easiest way to do it.

When you get the print dialogue box, make sure you select the adobe
program (NOT YOUR DEFAULT PRINTER).

Hope this helps.
 
J

Joe Schmeier

Thanks, but if I do that, I get a single pdf file that is many pages long. I
many single page pdf files.
 
Top