Hi Al,
Okay, if you are forced into using Word as a report writer, then I'd head on
over to the ElementKJournals.com web site, and purchase some past articles
from them. They published quite a lot in past years on this topic. You can
download a sample here, for December, 2002:
http://download.elementkjournals.com/ima/dec02/
However, without the text of the article that explains how it works, it
might be difficult to piece it together. I think you can get the article from
them fairly cheap (like, say, under $10). You'd probably save more than that
amount in your time by having the article available to read. They've probably
published other samples as well, so try giving their 800 number a call (you
can find it on their web page).
Good Luck,
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
:
Hi Tom,
Thanks very much for your response. Unfortunately, it has been decided that
it is not convenient to send it out in Snapshot format, for a reason that I
won't go into (long story!). As we will be sending these report out to
around 100 different external offices of varying computer literacy, it was
decided that getting them to download the snapshot viewer (they do not have
access on their computers) would be too difficult (as easy as it is???).
Confused? Yeah, me too (sorry).
Anyway, that would be a much easier option as far as I am concerned, but it
has been decided against (by others).
Your response is greatly appreciated
AC
__________________________________________
:
Hi AC,
Is the external organisation willing to accept your reports in the Snapshot
format? If so, it would be much easier to add your company's logo to the
report, if it is not already present, and then send the report as a snapshot
file.
DoCmd.SendObject acReport, "Report Name", OutputFormat:=acFormatSNP, _
To:="Email Address", Subject:="Email Subject", EditMessage:=False
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
:
Hello
I am currently sending reports in Rich Text Format via e-mail to an external
organisation. I am using visual basic to do this eg.
DoCmd.SendObject acReport, "Report Name", "RichTextFormat(*.rtf)", "Email
Address", "", "", "Email Subject", "Email Message", False, ""
Is there a way that I can use a template file in Microsoft Word when sending
this email, so that the document contains my companies logo etc.? EG. the
RTF file would attach itself to a template file somehow???
Any help/suggestions/ideas would be immensely appreciated
Thanking you in advance
AC