I am using Access 2002 - I have a Form where I allow a user to enter some
details then press a button to merge these with an 'Email Template' I
have written.

Using VBA I load the whole of the template text (from a standard .txt
file) - then substitute some placeholders with text from the form that
the user has entered. I have placeholders in the template using this type
of format [FIELD_NAME], then these are substituted for the appropriate
field text. It all works great and using;

DoCmd.SendObject outputformat:=acFormatTXT, To:=Me.recipient, BCC:
="sender.address.com", Subject:="Test Email",
MessageText:strMessageToSend, EditMessage:=True

I send it to Outlook Express to be sent - Again works great no problems.

I would like to add some new templates, but this time I would to generate
an email message in HTML format, so I can include logo's and pic's, plus
use color to format the text and fonts etc.

I have tried formatting the template using text entered into an HTML
email from OE, then just copying that out to the template file, but I get
a load of 'junk' type HTML code when doing that.

If anyone could give me a few pointers on how I might achieve my goal I
would be really grateful.


Thanks

Isis <isissoft (AT) NOSPAMbtinternet (DOT) com> wrote:

Hi!

I'm not familiar with that way of sending email, so these are just my 2
cents: have you tried changing outputformat parameter to acFormatHTML ?

HTH
Popi

Posted using www.webuse.net

"Popi" <2446invalid (AT) webuse (DOT) net> wrote in news:201106290754002446
@webuse.net:

Popi,

"SendObject only supports plain text. The acFormatHTML applies to the
object you might include as an attachment, not the text in the body of
the Email."

did a bit of digging !

Thanks very much for the idea though.

Regards

On Jun 28, 9:18*am, Isis <isiss... (AT) NOSPAMbtinternet (DOT) com> wrote:
Maybe:

http://groups.google.com/group/comp....b9bc2310f79329

James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com