Outlook email attachment with cover page

I have a template that I have created to mail merge to a list of people.  When I complete the merge it sends it as an attachment xxx.docx and that is okay.  That part works fine.  When the person gets the email, I would like to have something in the body of the email explaining about the attachment.  This would be the same for all emails in the mail merge,  Something like:
 Dear Customer,
 Here is your bill.
Thank you for business.
cambridge-techAcct MgrAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Christopher Jay WolffWiggle My Legs, OwnerCommented:

I'm not quite sure I'm getting this correct.  It sounds like you want to send individual unique invoice documents to your client base.  Each client would receive their own private invoice.  So if you have 69 clients, you have 69 invoices that are each matched to, and attached to the correctly addressed email.  Is that correct?

When in Outlook and select Mail Merge, it opens Word so you can use the Mailings menu on the ribbon.  After setting up your mail merge doc in Word, at the right end of ribbon on my Word 2013 is the final button, Finish and Merge with a little arrow down next to it for the Finish and Merge menu.  In that menu pull-down, you can choose Send Email Messages, and then get the dialogue for Merge to Email.  In that dialogue, you can select Mail Format.  The choices for Mail Format are Attachment, Plain Text, or HTML.

If you choose Attachment, your Word doc you set up with

Mr.  << full name >>,
Here is your bill.
Thank you for your business.

will be emailed as an attachment as you show in your post.  If you select HTML or plain, your doc will be formatted into the body of the email message.  One location for your doc (attachment) or the other location (in the body of the email).

What I think you want is something different that is more complicated.  Please correct me if I'm wrong.  I think you want some code to pick individual invoice files or data from a spreadsheet and send private unique invoices to each separate client.  If that's true, it depends on how your invoicing data is stored.  If you have all your clients in a single spreadsheet in Excel, you may want to put their data in the Word doc you set up to do the mail merge.  Could be a table in word, or I'd have to check, but maybe also an embedded Excel spreadsheet.

Does this sound right?
cambridge-techAcct MgrAuthor Commented:
One of our programmers was able to figure out and did have to add some code to the process.  Numerous tries but I think they have it now.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cambridge-techAcct MgrAuthor Commented:
This is no reflection on Christopher Jay Wolff.  Because I was not clear on the question, it was hard to give an exact answer.  I just got notice today from Experts Exchange of the comment and our programmer figured it out last week with the additional code that Christopher mentioned.  So it is not fair to him to grade on a vague question.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Email Software

From novice to tech pro — start learning today.