I'm working off of mailmerge VBA code that uses .MailMerge




now I'm passing values to from .MailMerge to field fields in Outlook.MailItem because I find it easier to reference the column using .MailItem


for example:



I'm trying to fill out .HTMLBody but it won't compile because I don't know how to use the mailmerge email body as a string or an html from .MailMerge that I can forward to .body or .HTMLbody for Outlook.Application / Outlook.MailItem




These my attempts so far:


declaring




with attempts such as

1. Quote:

   myItem.HTMLBody = .DataSource & myItem.Body

2. Quote:

   myItem.HTMLBody = .DataSource

If I can somehow use the MailMerge method to pass the the mail merge document to the body of the Outlook method it would really save me a lot of time


Please advise

Mailmerge doesn't automate Outlook, so code like you've posted is irrelevant in that context; you'd have to forego mailmerge entirely and automate Outlook instead, writing your own code for the entire process.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

In order to write to the html body, you need to use the Outlook Word Editor Inspector and then you can treat the body as if it was a Word document e.g.


This entry point at the start or the message body. As long as you know how to manipulate strings you can add whatever you want to that body.


Or you could simply use http://www.gmayor.com/ManyToOne.htm in one to one mode and merge directly to the message body

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com