Automation: Using Access 97 to Format Outlook Mail Messages 1

[tbaguio]

Hi,

I have successfully been able to use Access to send out Outlook email messages, but now I'm curious about formatting those messages through automation.

I know Access works well with Word to create nicely formatted documents but can you do the same with Outlook mail messages? I am interested in using basic formatting elements like Bold, Italic, Underline etc. Would the commands be the same as controlling Word?

Thanks. [sig][/sig]

 

[30Hobbes]

tbaguio,

The only thing I know that can to help is that when you are creating the email, instead of using ex.

mailItem.Body = "My Text"

use

mailItem.HTMLBody = &quot;<B>My Text</B>&quot;

I haven't tried it but the method is there and there may even be a mailItem.rtfBody as well.
Hope this helps.
30Hobbes [sig][/sig]

 

[tbaguio]

Hi,

Thanks for the tip. I tested it out and it works great! Unfortunately, 99.9% of my users are still using Outlook 97 and this method requires the Outlook 9.0 Object Library which is only in Outlook 2000. I guess I have more impetus for getting my users to upgrade...

Thanks again,
Theresa [sig][/sig]