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
Solved

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

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Read about achieving the basic levels of HRIS security in the workplace.
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
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…

808 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