Dorset Seagull
Once Dolphin, Now Seagull
I have a column of e mail addresses and need to merge them all together with a ; between each so I can put them in an e mail
Your time starts now....Go
Your time starts now....Go
Copy and paste the column into Word (paste special > unformatted). It should appear with each email address on a separate line (paragraph return), or with a space between them.
Then do find>replace, with the subject of "find" either a space, or a paragraph return or both (depending on how it's ended up formatted), and the subject of the replace being ";"
Copy and paste the result into the "to" field of your email.
I'm not sure you ned to put them all into a single string. Try this...
(Assuming emails are in column A)
1. In B1 enter =A1&";"
2. Copy that down the whole of column B as far as your email addresses go (double click the bottom right corner of cell B1)
3. Select column B
4. Copy column B
5. Switch to your email programme.
6. Paste
If it's Outlook you don't need the ';' anyway do you? I regularly copy a column of email addresses into the 'To:' field and then click into the body text of the email and Outlook inserts all the ';''s automagically (although maybe they have to be in a contact group first possibly).