Solved

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

Posted on 2014-03-26
1
705 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.

713 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