Mail Merge Word/Excel 2010 - Email letters as an attachment to retain Word formatting
Posted on 2014-03-26
After running a Word 2010 mail merge using an Excel database for variable information,
I want to send the resulting Letters to various emails contained in the database as an Attachment.
If I use the email function in the "Finish and Merge" within Word, I lose the formatting and the Header / Footers. The letters are about 9 pages long.
There are multiple entries in the database and I need to retain the "Merge record # n1 to Record #n2 option.
I would like to automate the entire process by launching it from Basic, Excel or Word using a macro or equivalent.
All sample code or examples would be most appreciated.