Send individual forms

  • Thread starter Thread starter wal50
  • Start date Start date
W

wal50

Each form contains details for one person. I would like to email each
individual their form (and only their’s) as a snapshot. No updating is
necessary; this is just information. The source of the form is a query and
the email addresses are available on each form. (Almost all of them).

When I select a record/form and try File>Send To, I get a forms for all
records. How should I proceed?

Thanks in advance,

Wal50
 
You need to setup a report filtered on the current record. Then you can use
the docmd.sendobject to email the report to the recipient.

An alternative would be to automate Outlook and loop through your query
results directly and use the records to populate the body of the message, but
this is more complexe to code.
 
You'd either need to place the data in the body of the email, or possibly
make a PDF, if your recipients do not have Access. You can use an add-in
such as:

http://www.lebans.com/reporttopdf.htm

to create the PDF and email it individually, or use something like:

http://www.win2pdf.com

to create the PDFs for individuals and:

http://www.groupacg.com/acgpdf.htm

to set up the recordsets to email them. If your users have Access or a
Snapshot viewer, they can view attached Access reports.
 
Thanks to both of you for the replies. I'll try these and get back if I have
problems.
wal50
 
Back
Top