By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,233 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Creating a Macro that will send a report via e-mail using different queries each time.

P: n/a
I currently have the tables set up and a separate query for each
individual sales rep. I then created 10 reports and a macro that sends
out the ten reports via e-mail to the correct reps.

I need to clean this up and have only one report that uses each
different query. Should I be using the Where clause? IF so how? I
have tried a dozen different ways.

The problem (and I knew this when I created the reports) is that one
change then has to be made to each of the ten reports. There must be
an easy way to have the report use a different Query each time.

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.