E-Mail Reports From Access

[westcobates]

Hello and good day.

I have a need to send a report to a specified number of
people from access. I use Outlook 2000. How can I do
this?

 

[MacDermott]

Look at SendObject.

HTH
- Turtle

 

[Tony Toews]

I have a need to send a report to a specified number of
people from access. I use Outlook 2000. How can I do
this?

You will need to use VBA code to run through a recordset either:
1) concatenating the email addresses to a string along with a comma,
sem-colon or other appropriate separater and then send one email with
all the bcc addresses;
2) individually send the emails.

Your method of sending emails may have some restrictions as to the
number of email addresses in the bcc field or the length of data in
that field.

For sample recordset logic see the Access Email FAQ at my website.

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