Exporting email addresses
I have been sent a list in excel 2007 of email addresses, all in one column,
each address in it's own row - a total of 670 addresses. There are currently no commas in each field. I need to paste these addresses into a bcc field in Webmail 2. Is there anyway to export these addresses as continuous text with commas separating them so I can paste them in? |
Exporting email addresses
Hi,
Its a bit lengthy procedure but it really works good. http://fightingback.googlepages.com/...datamanagement Create an Email Distribution List (is the heading of the topic) -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "gsquared" wrote: I have been sent a list in excel 2007 of email addresses, all in one column, each address in it's own row - a total of 670 addresses. There are currently no commas in each field. I need to paste these addresses into a bcc field in Webmail 2. Is there anyway to export these addresses as continuous text with commas separating them so I can paste them in? |
Exporting email addresses
Hey I use Excel all the time for email addresses
Just highlight all the cells you want and copy paste ! The only limits with my solution is I do this with Lotus Notes, Fastmail, and Outlook - never used Webmail 2. LN and O seem to work out the addresses themselves and put the appropriate characters in between. You may find they appear stacked vertically, but they send OK !! Find the best email system at Fastmail.fm I must be an XL nut because I use it for my daily diary and contacts (or LN which is forced on me by my dept is junk). It handles email addresses exceptionally well. If you have edited an email address in a cell, it will become active such that if you click on it, a new message window will appear in your email program. Love it!. So from that I have a table of contacts over which I have a huge amount of control, for sorting and filtering. I use Tag Crowd concepts for keywords and use the AutoFilter command Contains. Don't get me started about the benefits over Outlook..... 700 contacts and all the paraphenalia for less than 0.5Mb file..... To highlight a whole column, select the topmost cell and hold CTRL and press one down arrow, presuming the cells are contiguous. If that doesn't help, I need my head read WillBill "gsquared" wrote: I have been sent a list in excel 2007 of email addresses, all in one column, each address in it's own row - a total of 670 addresses. There are currently no commas in each field. I need to paste these addresses into a bcc field in Webmail 2. Is there anyway to export these addresses as continuous text with commas separating them so I can paste them in? |
All times are GMT +1. The time now is 11:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com