By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 892 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Sending rich-text email using access

P: 5
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?
.
Sep 11 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
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
Oct 4 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.