Select Agent Email Address & Send Filtered Report

[jujutsumaster]

I have a table containing "AgentName" and "AgentEmailAddresss".

I need to loop through the table and get each "AgentEmailAddress" in turn and use it as a query filter for "MyQuery" then use it to email the relevant filtered query results to each agent.

I know its simple to experts but I am stuck, can anyone please help me with sample code for the retrieve email address and filter query part?

I am using Access 2003

[Jim Doherty]

I have a table containing "AgentName" and "AgentEmailAddresss".

I need to loop through the table and get each "AgentEmailAddress" in turn and use it as a query filter for "MyQuery" then use it to email the relevant filtered query results to each agent.

I know its simple to experts but I am stuck, can anyone please help me with sample code for the retrieve email address and filter query part?

I am using Access 2003

For a sample of something of the type you speak about although not specific to you have a look at this thread and sample db I posted for another poster see the code behind it to give you a few ideas

http://www.thescripts.com/forum/thread744673.html

Regards

Jim

[jujutsumaster]

For a sample of something of the type you speak about although not specific to you have a look at this thread and sample db I posted for another poster see the code behind it to give you a few ideas

http://www.thescripts.com/forum/thread744673.html

Regards

Jim

Thank you Jim, I'll have a look at this.

Nigel