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?

In case you don't get a better response, I would use the "combine first and
last name" formula. It would look like this in Row 1:
Col A Col B Col C
(leave blank)
=A1&","&B1 result = ,

When you're done, you will still have a list. Highlight your whold list,
click on a blank cell of an empty row. Click "Paste Special". Check paste
"Values" and check the box that says "Transpose". Now your addresses should
be accross columns instead of down rows. You can now copy them in your email
address line.

--
sherry


"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?

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?

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?