Emailing from a query

[Robert Stanke]

Could someone please lead me in the right direction to get instruction on how
to do the following (NOTE: I have both Outlook 2007 and Access 2007 loaded on
my machine):

I have a query that pulls certain contacts based on a set of criteria. The
data results can be anywhere between 10-250 contacts. I want to be able to
trigger an email to go out to those contacts from the query. How would I do
this?

Thanks!

Robert

 

[Pat Hartman]

Queries don't have events so they are not capable of doing this. You need
vba code that reads through the recordset created by the query and sends the
desired email to each person in the list. Be aware that if you are using a
newer version of Outlook, you will run afoul of security. Take a look at
the emailer sold by FMS at www.fmsinc.com if you need to send bulk email.

 

[Arvin Meyer [MVP]]

As Pat mentions, you need to use a form to trigger an event. She also
mentions that Outlook will stop each email with a security warning if you
want individual emails to go out. Besides using SMTP or CDO, or a program
such as FMS's email app, you can also use Outlook Redemption:

http://www.dimastr.com/redemption/

to simply kill the warning.