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

Send multiple emails to user group

P: n/a
I have a table with user names and their balance. I am going to say
there are 1000 people that need to get an email of their balance
statement. I have one query that pulls the names and the corresponding
balance. I have one report called BalanceReport. I need to send this
report (for each different member) to their email. I would guess that
I would need to loop through the member list, and also only run the
query for the individual to create the report each time. I do not want
to create 1000 reports and 1000 queries, can someone please help? This
needs to be done in Access, and I am using the SendObject method unless
there is something better.

Sep 27 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Look at the downloadable example "EmailSenate2" at:
http://datastrat.com/DataStrat2.html
it could be just what you need.

-Ed

"Jeremy" <jc*******@rmhp.orgwrote in message
news:11*********************@e3g2000cwe.googlegrou ps.com...
>I have a table with user names and their balance. I am going to say
there are 1000 people that need to get an email of their balance
statement. I have one query that pulls the names and the corresponding
balance. I have one report called BalanceReport. I need to send this
report (for each different member) to their email. I would guess that
I would need to loop through the member list, and also only run the
query for the individual to create the report each time. I do not want
to create 1000 reports and 1000 queries, can someone please help? This
needs to be done in Access, and I am using the SendObject method unless
there is something better.

Sep 28 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.