470,641 Members | 1,535 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,641 developers. It's quick & easy.

Select Agent Email Address & Send Filtered Report

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
Dec 18 '07 #1
2 1812
Jim Doherty
897 Expert 512MB
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
Dec 19 '07 #2
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
Dec 20 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Ant | last post: by
5 posts views Thread by S.Dickson | last post: by
10 posts views Thread by Mike Charney | last post: by
1 post views Thread by bplim88 | last post: by
14 posts views Thread by Warren Tang | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.