email query results to several adresses

E

Ems

MSAccess 2003
Vba

Good afternoon,

I'dd like to export query results to excel and send the excelfile through
email to each person in a query. The e-mail address makes the person unique.

in this exaple I'dd like to send an e-mail automatically to E. Brown, first
export the query results for e. Brown to an excel file and automatically
e-mail the excelfile, I'dd like the same to happen for S. Johnson and S. de
Niro.

Can anybody help me?

Thank you very much,
Ems
qryProblems Name City Email Problem
E. Brown New York [email protected] Code 1
E. Brown New York [email protected] Code 2
S. Johnson Washington [email protected] Code 1
S. De Niro Boston [email protected] Code 1
S. Johnson Washington [email protected] Code 1
 
Top