Emailing reports to someone in database

  • Thread starter Thread starter SQL Brad
  • Start date Start date
S

SQL Brad

Hello...I am managing sales data for an antique mall, where we will have over
200 dealers. Our goal is to email a daily report to dealers with a listing
of their item sales and amounts. In terms of procedures, I will 1) download
an csv file with appropriate information..2) then run macro that runs each
individual report.

My tables are set up this way:

table1
department
departmentemail

table2
department
date
item
amount

My question is this..... if I only enter the email address in table1, how do
I have the macro email that specific report to only the email listed for that
department. I don't want to re-key any data.

Thanks
 
Further info:

I am wanting to use the sendobject command in the macro, but in the 'to'
field, I want the email address from table1 inserted automatically? How can
this be done?

thanks in advance for your help and suggestions.
 
Back
Top