I have a question that is similar to a thread started by pauljhorak; however, my needs are a bit different / possibly more complicated.
I have several files stored as outlook items (.msg).
I would like to place keywords inside the .msg body section that I can replace with field values from my table. For example, name, greetings, etc. The to: field in the message will also come from field values.
Also, I need to post a table into the body section of the meesage with the column (heading) portion hilighted, and would like to designate an area using keywords as to where this hilighted table can be placed.
As far as posting the table into the body, should I first save it to an excel file and then cut and paste the excel table into the body? Or is there a shortcut to this?
.
See if this helps:
In regards to your rich text questions, it is my understanding that Outlook actually supports four formats: Text, HTML, Rich Text, and Word. However, there is no RichTextBody or WordBody property that can be used; only the default BodyProperty and an HTMLBody property. The HTMLBody may meet your needs because it will handle the excel portion of your request (below)
In regards to your questions about the excel table, try following the steps below, which will enable you to send a table in the HTML Body without having to do any cutting and pasting:
Word 2000, Outlook 2000 were used, but it should also work in later versions.
1. make sure outlook is set to send e-mail as html (Tools/Options/Mail Format tab/select HTML from drop down list).
2. create a table in Word
3. Using the command menu in Word, click on the following:
File/Send to/Mail Recipient (not as attachment)
and then Send
5
