How to generate an email from access

H

Hemang Shah

Hello

I want to create a HTML email from access.

I want to be able to set the colors of some table cells in the email
depending on what users select on the access form.

How can I do this?

Any help would be welcome.

Thanks
 
D

Dirk Goldgar

Hemang Shah said:
Hello

I want to create a HTML email from access.

I want to be able to set the colors of some table cells in the email
depending on what users select on the access form.

How can I do this?
Click to expand...

I believe you'll need to use automation. For example, you can automate
Outlook, and set the .HTMLBody property of the mail item to the HTML
string you want to be the message. See Tony Toews' Access Email FAQ
page:

http://www.granite.ab.ca/access/email.htm

As far as editing the actual HTML, I'm not sure what would be the best
way to go about it.
 
Top