Quote Originally Posted by mso3 View Post
I'm in a urgent need of a macro to perform this mail merge.
It's rude to wait until something becomes 'urgent' then expect volunteers to drop whatever else they're doing just to help you. Furthermore, there is plenty of code about - both here and elsewhere - that already does most of what you say you want. All you need do is adapt it to suit your needs. For example, the code in the Send Mailmerge Output to Individual Files topic in the the Mailmerge Tips and Tricks threads at:
http://www.msofficeforums.com/mail-m...ps-tricks.html
and:
http://windowssecrets.com/forums/sho...ips-amp-Tricks
could be adapted in a couple of minutes.