E-mailing report

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

Guest

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
 
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
 
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.
 
Back
Top