How to email only one record (report)?

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

Guest

I have a run email macro button (sendobject) on a form. Once all data is
entered into the form, it spills into a new record report. I want to email
the one record (data from the last form input) only. Right now it sending
all records in the report. Does anyone have any ideas?
 
Lorisa said:
I have a run email macro button (sendobject) on a form. Once all data is
entered into the form, it spills into a new record report. I want to email
the one record (data from the last form input) only. Right now it sending
all records in the report. Does anyone have any ideas?
Click to expand...

For a page on how to print a report for a single record and how to generate reports
to attach to emails see the Emailing reports as attachments from Microsoft Access
page at http://www.granite.ab.ca/access/email/reportsasattachments.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Lorisa,

Base the report on a query, using the criteria of the query to restrict
it to return only the record you want for the report.
 
Back
Top