E-mailing report

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
 
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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

send report to e-mail 1
E-mailing a report 3
"Can't send this e-mail message" 1
E-Mailing a specific page of a report 1
E-mailing Report 2
Send Report via e-mail group 1
e-mail a report based on records in the query... 3
E-mail Merge 2

Top