Report data in email

[SandySun]

I have a Query with Email addresses and another Query with account numbers
and dollar amounts. Does anyone know how to insert the data from the Query
with account numbers and dollar amounts so that it goes to the individual
email address? Thanks in advance for your help.

Sandy

 

[Evi]

It would depend how your database is structured. What tables do you have in
it and what do they contain?
Evi

 

[SandySun]

Well I have two tables one that contains the name and email address (table1)
and the other contains the date, account number and amount (table2). What I
would like to do is email all email address the results in table2 for today
(I already have a query which filters the data for today)....but I would like
to send it to them in the body of the email instead of as an attachment. can
this be done?

Sandy

 

[Evi]

I can't see anything in Access 2000 that will do that. Anyone else with more
ideas?

Evi