Emailing reports to someone in database

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
 
S

SQL Brad

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top