I want to make sure this will work before I rack my brains out! I am
running
an antique mall where we will have over 200 vendors. I will get a
download
of sales that will include a department number, item number and dollar
amount. My goal is to run a macro that will email each vendor their sales
from the prior day (assuming they had sales)....I have set up the
following
two tables....
Department
Departmentnumber
email
name
Sales
departmentnumber
date
item
amount
I want to use the macro to send each vendor their information. Here are
my
questions:
1. Can I use dlookup to retrieve the email address asssociated with the
departmentnumber?
2. Will I have to write a re****t for each of the 200 vendors? or can I
just
use the dlookup to retrieve the sales amount?
Ideally, this is what would happen...
Assume in the example that I have the following departments with the
following sales:
department 101, $100
department 103, $200
In this case, two emails would go separately when I run the macro..email 1
should say $100, etc.
I hope this makes sense.....
Also, assuming I can use dlookup, can you please help me with syntax for
the
macro..
thanks in advance.
|
