Search results

DB...you were right...it sent it only once...and since we all use Outlook, that should be good. Thanks!

I am not sure if it does matter...to be honest...I won't be the one using it, but I also want to make sure that our server doesn't crash as it only sends to about 375 clients at once and then causes a delay for the others. I just want to make sure that won't happen.

OK, Mark...your checkbox idea was great. It works! The only question I have right now is how do I keep it from duplicating email addresses in the To: Field...so multiple groups have some of the same clients in there and when they check them off...it's duplicating the emails as well. Do you...

So Mark, I am going to try to fit your code with mine and see where it takes me. The database is set up so that multiple people can be in more than one group. Still, it gives me a good jumping point. Thank you Mark and DB, I will let you guys know how it turns out.

Mark, I would appreciate that as well. Check boxes may work better in this case.

Here you go, DB: SELECT [First Name] & " " & [Last Name] AS Name, tblStaff.Email FROM tblStaff WHERE (((tblStaff.[FRP DHS Referral])=True));

Each query has the list of clients in the group along with their email addresses, so when the user selected that group in the combo box, those specific email addresses were populating in the "To: " Field.

Good morning, all: So I'm quite new to VBA and just joined the site today, so I'm not sure I've posted this in the right place. I created a Combo Box to send group emails. The code is below. It worked great. However, the client wants to be able to send it to multiple groups at once, so I've...