Did you check the folder containing your mailmerge main document for the PDFs after running the macro? Did you add the macro to your mailmerge main document? Did you change the field names to suit your data, as indicated? Does your mailmerge main document generate an SQL prompt when you open it?

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