Create email from current record and sub-records

[Daveo]

Hi there,

I need to be able to send the details of the current record that is
displayed in a form and the linked records in a sub-form via email.
I'm not sure where to begin - can anyone give me any pointers?

Cheers - David

 

[Daniel Pineault]

There are basically 3 approches depending on your needs.

1. loop through the controls on your form and sub-form and build your e-mail
body and send an e-mail.

2. Create a report based on the current record an e-mail it using the
SendObject method.

3. Create a report based on the current record, convert it to PDF and e-mail
it using Outlook automation.

You can lookup the SendObject in the VBA help or search this forum, there
are numerous examples.

For Outlook automation you can take a look at
http://www.devhut.net/index.php?lang=en&id=0000000013

Also, this has been answered numerous time so I would suggest you search
this forum for "e-mail current record" or something similar to get more
advice/examples/links.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.

 

[OldManEd]

I have a similar problem. I have a table with about 500 records, each with
an e-mail field. I want to send the same e-mail to each. Per your suggestion
I search this forum back to April 1 using 'e-mail current record' without
any hits.

I have a variety of resources: Vista, XP, Office2003 and Office 2007. My
default e-mail reader is Windows Mail for Vista and OutlookExpress for XP.
Where do I start?

Is this an mail merge application? Your 2nd choice looks like what I need.
How do I use the SendObject method?

OldManEd