Multiple Email Addresses to Send Object

[MEDolin]

I'm hoping someone has some simple code that can accommodate my request. I have a form that matches tutors to students based on 2 sets of criteria. The user will then select 5 or more records to send an automated email. I have a query that contains these records selected as well as there email address.

My problem is that I do not now how to load more than 1 email address into the TO: section of the Docmd.Send Object.

Any help is appreciated

MEDolin

 

[Mile-O]

The easiest way is to loop through all of your records, obtaining the email addresses and building a string around them, appending a semi-coon after each email address, and then removing the final semi-colon.

 

[BukHix]

You may want to take a look at a sample.

Email Report! (2nd Listing)

For your case you may want to use some check boxes or a radio button or two to determine who should get an email. I am not sure how your app works so I can not be any more specific. Sorry.