Looping through filtered report e mails

[Wayne-I-M]

Hi

I have a code that sends out filtered reports and various "stuff". The user
selects the client from a combo and this sends the report.

Is there a way to send the reports to each person in the combo (about 20
major clients). The reports are fillered by the client ID (col 0 in the
combo)

Basically looking for a looping code that does not use the recordset to send
one report to multiple people (no problenms with that) this is a list of
people getting the same basic report but that has been filtered - so the
reports are slightly different

eg.
ClientID 1 - send to (e-mail address removed)
Your booking to date are 123

ClientID 2 - send to (e-mail address removed)
Your bookings to date are 789

etc

 

[pietlinden]

Hi

I have a code that sends out filtered reports and various "stuff".  Theuser
selects the client from a combo and this sends the report.

Is there a way to send the reports to each person in the combo (about 20
major clients).  The reports are fillered by the client ID (col 0 in the
combo)

Basically looking for a looping code that does not use the recordset to send
one report to multiple people (no problenms with that) this is a list of
people getting the same basic report but that has been filtered - so the
reports are slightly different

eg.
ClientID 1 - send to (e-mail address removed)
Your booking to date are 123

ClientID 2 - send to (e-mail address removed)
Your bookings to date are 789

etc

If you had a listbox instead, then it would be a walk in the park.
There's code at www.mvps.org/access in the modules section to loop
through the items in a listbox (or the itemsselected collection).
Then you would just process inside of that loop.

 

[Wayne-I-M]

Thanks for that - I will have a look in the morning