using sendObject

[Andy Levy]

Hi ya

I am trying to produce an HTML email through access. It works ok, until i
put in the image content. Does anyone know how to put in the html code as
part of a SendObject ? This is incorrect but demonstrartes what i am trying
to do.

Thanks

DoCmd.SendObject acSendNoObject, , acFormatHTML, , , , , "<IMG src
= 'http://www.web.com/image.jpg' ><br> Dear " & myVar1 & " " & myVar2, True

 

[Rick Brandt]

Hi ya

I am trying to produce an HTML email through access. It works ok, until i
put in the image content. Does anyone know how to put in the html code as
part of a SendObject ? This is incorrect but demonstrartes what i am trying
to do.

Thanks

DoCmd.SendObject acSendNoObject, , acFormatHTML, , , , , "<IMG src
= 'http://www.web.com/image.jpg' ><br> Dear " & myVar1 & " " & myVar2, True[/QUOTE]

I don't think what you're attempting is possible unless they changed something from
Access 97. The argument acFormatHTML is establishing the format of the object, not
of the Email message and you are not sending an object so it accomplishes nothing.

The only way I know to send an HTML mail is to automate the Outlook libraries.
Outlook messages have both a Body and a separate HTMLBody. If the message content is
placed into the latter, then the message produced will be in HTML format.

 

[Jim McDonald]

Andy - I think the problem my be in the http: addess in that Access has
problems fetching/linkin via a URL.
Have you tried the same thing with a locally stored image?

Jimbo