I have been using Macropod's code to mail merge into individual files.



However, is it possible to create option to choose merge to .pdf or to .docx?

Thanks!

The macro already has code for both. If you want to be able to choose between them, you need to solicit some input that can then be tested as the macro runs. Alternatively, of course, you could just have two versions of the macro: one that outputs documents; and one that outputs PDFs, without the need for additional code for choosing (i.e. you simply choose which version to run from the macros box).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]