Emailing a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have WinXP and MS Office 2003. I am using Access 2003 and have built a
report. On the report I inserted an object, a word doc in letter format, and
added fields from the fields list to the word doc. The problem is I want to
email the report and the only thing thats shows is the field list items and
not the word doc. How can I get the report to email the whole the letter
with the data from the field list items on it? Thanks for any help.
 
Tina,
I havent done this myself, but i researched the question alittle bit on the
internet and I found a pretty good website that describes how to email stuff
in outlook etc.
http://www.granite.ab.ca/access/email/outlook.htm

I'm not sure how you exactly want to do this, such as do you already have
the email addresses that you'd be sending to and then mass mailing Word
documents out to them or each time you create a report do you want to be able
to export it to a word document and attach it to an email where you can type
in the email address? Read up on that site as it has examples and good
tutorials from microsoft.

I've only done something like this using Novell Groupwise and i dont have
access at the moment to using outlook so i cant test this stuff myself.

Best of luck and i hope it helps,
Tim
 
You are probably going to need to ouput the report to a file, either
in Snapshot format or by Printing it to a PDF "distiller", and then
write code in the Report's OnClose Event to email the file as an
attachment.


I have WinXP and MS Office 2003. I am using Access 2003 and have built a
report. On the report I inserted an object, a word doc in letter format, and
added fields from the fields list to the word doc. The problem is I want to
email the report and the only thing thats shows is the field list items and
not the word doc. How can I get the report to email the whole the letter
with the data from the field list items on it? Thanks for any help.
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Back
Top