Access & email

  • Thread starter Thread starter Guest
  • Start date Start date
G

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...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?
 
PeterM said:
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?
Click to expand...

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.
 
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.
 
Back
Top