WordMailMerge Automate Saving indiviual pdf files for each recipent.

[Torinjr]

Hi all,

I currently have a command button that i click to run a WordMailMerge macro for a query that i have created. This part works fine.. I then get prompted to find the word document file i want to merge (which i would like to automate so i can save time finding the document).



The word template has been saved with query fields that i want merged in their rightful places so the user does not have to manually add these. The next step i would like is to be able to save the indivual files as pdf's for all the recipients (again automated). Currently i can do this manually by selecting the chosen recipient and going save as pdf and saving under a new pdf name, but it can be time consuming.

Does anyone have code or advice for me? I am fairly unexperienced with vba but am willing to give it a go for this...

Thanks.

[rpeare]

if you are still working on this....

you'd have to do this with code, likely by cycling through a recordset and performing the export/merge for each record as you go. Have you got code or an example of the query that you're currently running? if it's in the form of a macro can you convert the macro to vba and post the vba for analysis?

[ItsMe]

I would guess that you would have to automate Acrobat. You might be able to automate Word and change the default printer to a PDF printer though.