Report data in email

  • Thread starter Thread starter SandySun
  • Start date Start date
S

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
 
It would depend how your database is structured. What tables do you have in
it and what do they contain?
Evi
 
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
 
Back
Top