merging to many one page files

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.

I found a utility or two that can convert a folder full of .doc files into
pdfs, so I would like help writing a macro that can step through the database
and save each page as its own file.

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...
 
Top