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
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