Column to list (1 Viewer)

[Gismo]

Hi All,

please help again

I need to convert email addresses from a table to a comma delimited list

From Email_Address
email1
email2
email3

to email1;email2;email3


please could you assist?

 

[bob fitz]

I need to convert email addresses from a table to a comma delimited list

Just curious. Why do you need a value list rather than binding the listbox/combobox to the email table

 

[theDBguy]

Hi. Maybe this would help.

Code Snippets

 

[arnelgp]

use Allen Browne's ConcatRelated function.

 

[Isaac]

I highly recommend you take this opportunity to write the code yourself. It's very easy to write, so perfect for doing it yourself - you'll learn alot and there is no need to paste code from the internet for something so relatively easy to re-write. Your skills will be much better off for it!

1. open a recordset with the email address
2. declare a string variable
3. loop through the recordset
4. populate the string variable
5. close the recordset

 

[Uncle Gizmo]

Display Field Data Horizontally - Nifty Access​

More info on my website here:-

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

Along with a download. You can get for free, contact me for details...

 

[bastanu]

And you already have the code in your other thread about (CDO) emailing with GSuite.

Outlook to Gsuite

Hi All, We have migrated from Outlook to GSuite Some users are still using Outlook for a few months. I now have to rebuild all my VBA codes to send to gmail Please could you advise on how to adjust my VBA code any chance to have the VBA code to check for GSuite users or Outlook users to have...

www.access-programmers.co.uk

Cheers,

 

[Gasman]

use Allen Browne's ConcatRelated function.

theDBguy's function is a lot easier to use?