... (1 Viewer)

[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.

 

[Uncle Gizmo]

build a comma separated string

My blog here demonstrates one method:-

Display Field Data Horizontally - Nifty Access

Transform, Concatenate Examples A common requirement in MS Access is to extract Columnar data into horizontal data, for instance to make reports look better, to provide a list of emails suitable to send to with Outlook. In the YouTube videos below I explain how this can be done. Display Field...

www.niftyaccess.com

 

[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.

 

[Uncle Gizmo]

I think they were valid questions asking for clarification.

So do I.

 

[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?