Access & email

[Guest]

I need to create an .html formatted email from scratch using VBA and then
present the email for reveiw prior to sending. I can accomplish that very
easily via DoCmd.SendObject...the problem is that a plain text format is used
for the SendObject even though I specify html format.

How do I create an .html formatted email in VBA? Help would be greatly
appreciated...thanks in advance!

 

[Allen Browne]

Good place to start might be the Email FAQ put together by Tony Toews:
http://www.granite.ab.ca/access/email.htm

 

[Guest]

Allen...thanks for responding...unfortunately there are no examples or
mention made of creating an html formatted email using only VBA at the web
site you mention. I can't use third-party controls or add ins.

Is there somewhere else I can find help?

 

[Dirk Goldgar]

Allen...thanks for responding...unfortunately there are no examples or
mention made of creating an html formatted email using only VBA at
the web site you mention. I can't use third-party controls or add
ins.

Is there somewhere else I can find help?

I'm pretty sure that if you are in a position to automate Outlook, you
can use code modeled on that in this KB article ...

http://support.microsoft.com/?kbid=161088
Using Automation to Send a Microsoft Outlook Message

.... but set the message's HTMLBody property instead of the Body property
to send an HTML-formatted message. Naturally, the string you set the
HTMLBody property to must be valid HTML.

 

[Steve Schapel]

Peter,

Specifying HTML format with SendObject refers to the format of the
Object, presumably a report, which you are Sending, so it refers to the
file attachment rather than to the format of the email itself.