SendObject acHTMLFormat Ignored?

[Jim Doc]

Hi All...I wasn't sure which group to post in but I thought this one seemd
appropriate.

I am outputing a report with SendObject using acFormHTML from Access2002 to
Outlook2002. Everything is perfect, except that no matter what I seem to do
Outlook automatically creates a "plain text" message and I really need an
HTML message.

Any clues as to how to force Outlook into HTML format??

Thanks Much!

 

[Rick Brandt]

Hi All...I wasn't sure which group to post in but I thought this one seemd
appropriate.

I am outputing a report with SendObject using acFormHTML from Access2002 to
Outlook2002. Everything is perfect, except that no matter what I seem to do
Outlook automatically creates a "plain text" message and I really need an HTML
message.

Any clues as to how to force Outlook into HTML format??

Can't be done with SendObject as far as I know. You would have to automate
Outlook or CDO (or other messaging library) that supports creating an HTML body
as opposed to a plain text body. The acFormatHTML argument is for attaching a
report, form, etc, as an attachment to the Email. It does nothing to the body.

 

[Jim Doc]

Hi Rick thanks for the response. I've not done any automation yet, can you
point me in the right direction to invoke an Outlook object?

Thanks
Jim

 

[Tony Toews [MVP]]

Hi Rick thanks for the response. I've not done any automation yet, can you
point me in the right direction to invoke an Outlook object?

See the Outlook specific links at the Access Email FAQ at my website.
http://www.granite.ab.ca/access/email/outlook.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Jim Doc]

Tony Thanks so much! I reviewed your web site as you suggested and was able
to get eberything working in just a matter of hours!! Well, almost...I
can't find any properties for forcing Outlook to use the defined stationary
or signatures...If those could work, my solution would be totally automated.
The signatures have photos of the sales person in them. They can insert the
logo at the top and their signature at the bottom, but its just so ...
unelegant (if that's even a word!!)

Thanks again you were a huge help!!

 

[Tony Toews [MVP]]

Tony Thanks so much! I reviewed your web site as you suggested and was able
to get eberything working in just a matter of hours!! Well, almost...I
can't find any properties for forcing Outlook to use the defined stationary
or signatures...If those could work, my solution would be totally automated.
The signatures have photos of the sales person in them. They can insert the
logo at the top and their signature at the bottom, but its just so ...
unelegant (if that's even a word!!)

Well, that is possible that would work. If you set a reference to
Outlook you should be able to browse the object model and possibly see
those stationery and signature options. Well, now that I take a look
I don't see any such.

Hmm, would CreateItemFromTemplate work?

You could try asking in the Outlook VBA newsgroup.

Note that you'll want to use Late Binding once the app is debugged to
handle workstations that don't have Outlook installed or a different
version of Outlook. Even if this doesn't happen now it will happen
when your IT staff starts to upgrade some of the workstations to a new
version of Outlook.

"Late Binding in Microsoft Access" page at
http://www.granite.ab.ca/access/latebinding.htm

Thanks again you were a huge help!!

You're quite welcome. Comments like yours make the effort worth
while.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm