Thanks for your info. Personally, I have never, ever seen "script" used in place of macro. Point me to that please. My apologies if it caused confusion. So forget the word, "script" and in its place simply use the word "message"

If one is using Excel for the database, Word as the word processor, and Outlook as the email vehicle, then one need not do any VBA programming. Of course I guess it's possible to formulate a program to automate the process even more, and perhaps even more applicable if one is not using Outlook or Word? I've only done mail merge with the above.



"In a nutshell," type your message in Word - insert "placeholders" where you want specific information, e.g., names, addresses, etc, Have those data in an Excel worksheet, preferably in the same sequence as they appear in your message, in addition to the individual email addresses that go with those data. While in Word, begin the "mail merge" process, accessing the Excel workbook with the data, finish the process by pointing Word to the email addresses in Excel. That's it, off to the races.

Happy Holidays to All!!

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]