separating emails with semi colon

  belayer 19 Dec 12
Locked

I have a list of email addresses I want to use. At the moment I have them as a text and as a list in Excel.

I would like to have them as a Word Doc list with a semi colon and space between each one so I can just Copy and Paste the list into an email.

Is there an easy way to do it?

  Sea Urchin 19 Dec 12

There is nothing to stop you doing just that. Type the list in Word as you specify - in a continuous line (no line breaks) and then you could copy and paste into the To: line of your mail. But I would suggest it would be far better, and less clumsy, to make up a group in your email program and send the mail to that group.

  belayer 19 Dec 12

Its a list of a few hundred, I already have them in a list but I can't use it for emailing because it has to have each address searated by a semi-colon and a space first.

I just thought there must be a command that will do it for me.

  Sea Urchin 19 Dec 12

If you send a list of a few hundred then your ISP will most likely consider that you are spamming - and will not send them.

I'm not quite sure what type of "command" you are thinking of. However you do it you would need to prepare the list first

  belayer 19 Dec 12

Let me start again.

I have a list of association members in Excel with their names and addresses and other details. I want to extract the column of email addresses to use it in Outlook and convert them into a format that Outlook accepts (a semi colon and space between each name) and save it in a text/doc format so I can copy and paste it into the email box to send news items to members.

My ISP is perfectly happy that I do this and will deliver them.

  lotvic 19 Dec 12

Copy your text file to a Word document.

In Word on the Edit menu you have 'Find and Replace' that should do the trick if your text file has used commas to separate each address replace the comma with ; (type a ; and then a space) then click on Replace All.

If it is a list with each email addy on a new line then in 'Find and Replace' click on Special and choose 'Paragraph Mark' and replace with your ; (type a ; and then a space) then click on Replace All.

  lotvic 19 Dec 12

Tip: when you do send the emails, use your name in the To: line (or Insert "Undisclosed Recipients" in the To: field, followed by your email address in "<,>" braces) and paste the List of names into the BCC: line. (Blind Carbon Copy) Here's the instructions

If you don't then each one of the recipients will receive the long list of everyones email address. It will only take one pc to be infected and the whole lot will be harvested by the Spammers.

  belayer 19 Dec 12

Thanks for that, its pretty much what I needed.

Thanks

I do this all the time. Copy the column of email addresses into a Word document. Click in the column, then go to 'Table in Excel. Click on 'convert', then 'table to text' (this is all Office 2003 - it may be different in other versions, but the principle probably still applies). Now, you'll be given a choice of how you want he field separated. In theory, you ought to be able to choose 'other' and use a semi-colon. I've never been able to get this to work, so I leave it as the default - paragraph mark. Then, when it's done, I use Word's search/replace to replace paragraph marks with semicolons. It sounds laborious, but it's actually very quick - and a whole lot quicker than the alternatives..

Advertisement

This thread is now locked and can not be replied to.

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

IKinema aims to banish droopy shoulders and wonky spines in animated CG characters

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message