Sending a fixed e-mail

[Scott]

I have a query that I designed to show me all individuals who still have work
pending that needs to be completed.

Is there a way to get an e-mail sent to all individuals on this list via a
seperate e-mail. The To: and CC: would be variable based on a value on the
record, but the subject and body would be a fixed statement.

Any help would be greatly appreciated.

Thanks...

 

[Armen Stein]

I have a query that I designed to show me all individuals who still have work
pending that needs to be completed.

Is there a way to get an e-mail sent to all individuals on this list via a
seperate e-mail. The To: and CC: would be variable based on a value on the
record, but the subject and body would be a fixed statement.

Any help would be greatly appreciated.

Thanks...

A couple of ways:

1) To automate it fully, open a recordset on that query in VBA code.
Loop through the recordset, and for each record use SendObject to send
an email. You can look up working with recordsets and SendObject in
help or any Access VBA book.

2) With no code at all, but more work each time, use Word MailMerge to
send an email. For the data source, point to your query in Access.
Word actually does a very nice job of sending out emails by the
hundreds or more.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com