How to generate an email from access

  • Thread starter Thread starter Hemang Shah
  • Start date Start date
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
 
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?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top