Email reports to many addresses

[jevans]

In my database I have a Salesmen Table with the following fields: Sales-ID, Name, E-mail address. I have a report which is generated from a query based on Sales-ID. Can I email this report to each salesmen by linking to email address in the table to the report? I'm looking to email mutli-users with a one button click control. Can it be done?

 

[Talismanic]

jevans, does the list of salesmen stay the same and is it very long?

 

[jevans]

The Salesmen table is approx. 40 users long and yes it's constant.

 

[Talismanic]

A couple more questions.

1. Will every one get a report every time?

2. Are you on a network where you can group them with a distribution list, something like Exchange Server?

 

[jevans]

Answer:

1. No, everyone won't get a report every time.

2. I use Outlook 2000 which is connect to an Exchange Server.

 

[Atomic Shrimp]

I have a demo database that does something like this... would you like a copy?

If so, please email me (with 'email demo' in the subject line) and I'll send the demo by reply.

Mike