How can I concatenate an e-mail list from excel to paste in Outlook.

[Dude to Excel Dude]

Hello,

Question is: How can I concatenate a e-mail list from Excel so I can copy and paste the end result into Outlook.

Example

[email protected]
[email protected]
[email protected]
[email protected]
etc...

I would like to learn a formula that gives me this result so I can be able to copy/paste into an e-mail/Sharepoint list:

End result in same sentence: [email protected]; [email protected]; [email protected]; [email protected]; etc...

Thank you in advance.

[etaf]

you may not need to cocatenate them together
if you put in the cell next to the emails
assuming the emails are in column A starting row2

in B2 put

=A2&";"

and then copy the rows in B
and paste into the To: box on outlook
its clever enough to then put them all in one line

and then you can copy that line and put into any other application

just tried it and it worked in outlook for me
and then copy and paste here =
[email protected]; [email protected]; [email protected]; [email protected]; [email protected]; [email protected]

[Dude to Excel Dude]

Thanks for the trick. It is a useful one. However, when getting the names into Outlook, the address list will bring up the whole name after refreshing.

Example:

E-mail list copied and pasted into Outlook results - [email protected] - e-mail refreshes automatically and brings up "John Deere (Financial Guy - Europe) <[email protected]>", which will cause not to work in SharePoint because it doesn't contain the correct syntax "[email protected]; [email protected]; [email protected]".

I need to only sort it as [email protected]; [email protected]; [email protected]; so I can use this syntax, copy it into a SharePoint permission list and give access to a whole bunch of people. Do you know how can I accomplish this?

[Dude to Excel Dude]

I figured it out:

Having your 4 e-mail starting in row A2:

[email protected]
[email protected]
[email protected]
[email protected]

Concatenate in Cell B2: =A2&"; " will give you "[email protected]; " - Drag down to apply same formula to rest of mails.
Concatenate in Cel C3: =B2&B3, will give you "[email protected]; [email protected]"
Concatenate in Cel C4: =C3&B4

Drag down and as a result you get: "[email protected]; [email protected]; [email protected]; [email protected]"

Regards