VB Code to create Email list

[rizmomin]

Hello:

Please refer to attached file.
I have lots of email addresses in column C as shown.
I need VB Code to get the list of email seperated by ";" and save in txt file C:\GroupA_Email.txt.

Let me know if you have any questions.
Thanks.

Riz

[CK76]

With your sample something like below.

Please Login or Register  to view this content.

Notes:

• I don't recommend writing directly to "C:\" root. Use "C:\Temp\" or some other folder.

• If list exceeds transpose limitation, first place range into variant array and then transform and join. Or you can loop and concatenate.

[rizmomin]

Hello Ck76:

Thanks it works..

Riz