Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Mail Merge Word/Excel 2010  - Email letters as an attachment to retain Word formatting

Posted on 2014-03-26
1
Medium Priority
?
732 Views
Last Modified: 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.
0
Comment
Question by:BigMacBldr
1 Comment
 

Accepted Solution

by:
BigMacBldr earned 0 total points
ID: 39957449
I am embarrassed. I just answered my own question after reading other answers.

Word 2010 provides a drop down box where we can Choose "Send as an Attachment" instead of "Send as HTML". It works perfectly for my application.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Introduction to Processes
Loops Section Overview

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question