Inserting Contents Of Formatted Form Letters Into an Outlook 2002 Message...

[Michael Martin]

Dear Colleagues: I'm working on an App that generates form letters with
special text formatting, nothing too complicated - and the form letters
include a scanned signature (a .bmp file). The client wants to send these
form letters to certain customers via email. The email recipient data is an
Access 2002 Database. I have no problem creating the Form Letters with a
mail merge in Code and no problem creating and mailing messages from Outlook
in Code using VBA (CreateObject, CreateItem, etc.). My problem is getting
the formatted Form Letter into the Body of the message (the Body property of
the Message). I could copy each Form Letter to the clipboard and use
SendKeys to paste into a new Outlook message, bit I know there's a better
way, perhaps using a Form or embedding the Form Letter into a Field in an
Access Database, etc. I'd like to preserve the formatting, i.e. not set
the Body property in plain text. If worse comes to worse I could suggest
to the client that all formatted documents would be sent as attachments, but
that is a last resort. All suggestions welcomed, thanks for reading this.
Michael Martin
(e-mail address removed)

 

[Ken Slovak - [MVP - Outlook]]

I usually use a formatted Word template and use code to put whatever custom
data is needed from the source into the Word doc. Then I use Word's File,
SendTo menu item to send it as an email item.