Solved

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

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Convert number to hex in Lua 16 87
Oracle Mulit-site configuration 28 73
Deny sending to more than 2 recipients in Exchange 2016 2 46
Move a Database to a different server 4 59
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

732 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