Sending Email Automatically

[Marco Zingaro]

Hello,
I would like to create a FORMATTED Outlook Message automatically using VBA,
getting fields from a Word template, or vice versa (creating a Word document
with Outlook fields), for paper-archiving purposes.

What is the easiest way to do this? I'm assuming creating an HTML email
from the Word document.

So far I have a macro in Word using a script I found (GetObject("",
"Outlook.application"), Set mItem = mOutlookApp.CreateItem(olMailItem) etc .
.. . ) in which I fill out all fields except the main body, where instead I
copy the Word body to the clipboard and have to paste manually. That way the
formatting is maintained. I'm sure there's a better way to do this.

Help!
Thank you.

 

[Doug Robbins - Word MVP]

The code in the article "Mail Merge to E-mail with Attachments" at:

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

uses the body of a document as the content of an email message. You will
probably need to use the FormattedText attribute to preserve the formatting.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP