?
Solved

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

Posted on 2014-03-26
1
Medium Priority
?
719 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
In this article, we’ll look at how to deploy ProxySQL.
Progress
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

800 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