send email to each address query vba

[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 (e-mail address removed) Code 1
E. Brown New York (e-mail address removed) Code 2
S. Johnson Washington (e-mail address removed) Code 1
S. De Niro Boston (e-mail address removed) Code 1
S. Johnson Washington (e-mail address removed) Code 1

 

[Jeff C]

Michael Alexander has a website called datapigtechnologies. There are
some 50 flash movies offering tutorials and ideas on how to resolve
alot of issues. One of them deals directly with what you are trying to
do. In addition to these newsgroups I have found his website AND his
new book very helpful.