See, for example: http://www.ehow.com/how_7198112_write-vba-script.html, http://wiki.imacros.net/Excel_VBA_Example_Code, http://www.vistax64.com/vb-script/19...ipt-macro.html



The rest of your reply still doesn't address how to attach a PDF file to an email via a mailmerge. No-one is questioning whether you can create email messages via a mailmerge without a macro. But attaching a personalised file of any kind cannot be done via mailmerge field coding - a macro is required - which is why I pointed the OP to a ready-made solution.

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