...

[jazsriel]

...

 

[June7]

Need to build a comma separated string of the multiple email addresses.

Post your code.

If you want to provide db for analysis, follow instructions at bottom of my post.

 

[arnelgp]

you create a table of Contacts and put their name and email.
see this modification.

 

[arnelgp]

here i also add button to CC (if you like you can delete it).

 

[June7]

Is this a split db with multiple simultaneous users? If so, they will conflict in checking a field in table. But yes, code can check/uncheck all.

 

[June7]

Most likely need another yes/no field in table and separate buttons on form.

Or use multi-select listboxes instead of checking fields.

 

[June7]

"running into problems" means what - error message, wrong result, nothing happens? Exactly what do you not understand about suggestions?

 

[June7]

Wasn't meant to be snide, just brief. I think they were valid questions asking for clarification.

I don't understand why not pull from same list. If you have two distinct groups then have another field in table to identify that and use it to filter records for lists.

 

[June7]

There is no field named sfTOalt.
Why does each table have both TO and CC fields but not both displayed on form?
Why does each form run UPDATE of Contacts table?