E-mailing report

F

FollanA

Hi All,

Following on from my previous post in regards to displaying the last record
in a report. Now I need to automatically e-mail that single page to an e-mail
address.

I tried to use the DoCmd.SendObject function but this sends all the records
again (there goes all my hard work form before).

How woudl I incorporate the e-mail step in tot he code to only send the last
record, there does not seem to be a where clause in the function?
Cheers,
Andrew
 
B

Bill

Andrew,
Do a search in this newsgroup for "MailTo:". I think you'll find a post
that Albert made several weeks ago that addresses what you want to
do.
Bill
 
N

nycCTM

Not sure if this is what you are looking for, but if you have the full
version of Adobe Acrobat you can print to that which creates a PDF. Then you
can e-mail the PDF. I do this all the time.
 
Top