Emailing from a query

[William5271]

I need to send emails from an access database, but I want to send them from a
query so that I only email the cetian people. Access says that it can't send
an email from a query.

Any ideas?

 

[William5271]

Sorry, I figured out the problem.

 

[lydia]

So how did you do it. I'd love to know.

Sorry, I figured out the problem.

 

[fredg]

So how did you do it. I'd love to know.

Check out the Email Senate or the EmailSenate2K downloadable sample
databases at:

http://www.datastrat.com/DataStrat2.html

It uses the full table (only 100 Senators) but you would simply
create a query with the list of filtered names and addresses and use
that as the basis for the email list.