eMail to multiple receipients using table

[dorandoran]

http://www.tek-tips.com/viewthread.cfm?qid=873239

I would like to continue with the thread. I want to know how MJD1 took care of his problem. Because lotus notes still not sending e-mails to all the recipients in my List box called ListCC

 

[fredk]

Not sure but what I did was create a group in lotus notes and then refer to the group when I ran my code. That worked.


Fred

 

[AlexCuse]

I would write a loop that goes through all the ID numbers you want to send an email to, and creates a string like this:

StrEmail = "email1; email2; email3...."

And then in your message creation use .To = StrEmail

This may not be the most efficient way, but it beats looping through the whole email send for each address...

Please post when you get your solution, email automation is one of my favorite things in Access.

Good Luck,

Alex