EMailing a Report

[Beth B.]

Hello All! My question pertains to e-mailing reports using
the SendTo object. When doing this, not all the
functionality of Outlook is available. I'm using MS Access
2002 and Outlook 2002, btw.
The heart of the issue is logos. Not all customers this
is being mailed to have the same software, so I cannot use
Snapshot to send reports to everyone. When using HTML,
Rich Text, or any of the other options, the logos are
getting cleaned off. The easy answer to this would be to
publish the report with MS Word, but my boss wants
something that any user, savvy to beginner, can just be
able to use by accessing the database, opening the desired
report, and e-mailing using the SendTo object.
As a fix to this, I decided to just send the logos as
part of the e-mail heading instead of worrying about them
on the reports. We have a stationery with the desired
logos, but going back to the first paragraph here - when
using the SendTo object, not all functionality is
available - I can't use stationery. Furthermore, I created
a signature with our logo, and the logo does not appear
when using the SendTo object, even though it will let me
insert signatures (it will not even present the option of
using stationery).
Any advice on how to accomplish this?

Many thanks in advance.

Beth

 

[SA]

Beth:

SendTo is a very simple (as you've found) mail interface. It doesn't
support much of anything special other than who to send the mail item to and
what object to send. Secondly, when exporting a report, Access will never
output logos or any other graphics (e.g. lines, rectangles etc.) unless you
use a Snapshot. Of course you could easily add a link in your mail items
as to where to download the snapshot reader from the MS web site.

(Currently
http://www.microsoft.com/downloads/...3F-6D74-423D-8274-8B7E6313EDFB&displaylang=en)

The other work around is to output in PDF format (where most folks have the
reader) to maintain all the graphics. When doing this you'd need to
program the interface with Outlook more extensively (see the Outlook help
file, or the MS Knowledgebase) or use a third party tool to interface with
Outlook or the mail subsystem. (see www.slipstick.com see the developer
section, http://www.dimastr.com/redemption/ and other third party controls.)
In that vein you'll find our PDF and Mail Library for Access on our web.

HTH

 

[Beth B.]

Steve:

Thanks much for your reply. I will give this some
thought and pursue one of your excellent suggestions.

Best Regards,

Beth Betts