Export to comma-delimited format doesn't seem to work

[Patty Ayers]

I apologize for the elementary question. I have an Excel spreadsheet which
is simply a list of email addresses. I want to export them to a format
allowing me to paste them into the "To" field of an email. (In case you're
concerned, this is not unsolicited bulk commercial email). I've been able to
export them to a .csv format, but it doesn't seem to have the commas, which
confuses me and my email software.

Any help will be much appreciated.

 

[Jim Rech]

Put "a" in A1 and "b" in B1 and save as a CSV file (File, Save and change
the Save As type to CSV).

Then open the resulting CSV in Notepad. You should see a,b if your list
separator character is a comma.

--
Jim
|I apologize for the elementary question. I have an Excel spreadsheet which
| is simply a list of email addresses. I want to export them to a format
| allowing me to paste them into the "To" field of an email. (In case you're
| concerned, this is not unsolicited bulk commercial email). I've been able
to
| export them to a .csv format, but it doesn't seem to have the commas,
which
| confuses me and my email software.
|
| Any help will be much appreciated.
|
| --
| Patty Ayers | www.WebDevBiz.com
| Free Articles on the Business of Web Development
| Web Design Contract, Estimate Request Form, Estimate Worksheet
| --
|

 

[Patty Ayers]

Jim, thank you for this. The file I'm exporting from has date in A1, A2, A3,
etc. - all in column A. Will that work as a CSV?

 

[Jim Rech]

The best way to find out how a given type of data is saved in a CSV is to
try it on a small sample.

--
Jim
| Jim, thank you for this. The file I'm exporting from has date in A1, A2,
A3,
| etc. - all in column A. Will that work as a CSV?
|
|
| --
| Patty Ayers | www.WebDevBiz.com
| Free Articles on the Business of Web Development
| Web Design Contract, Estimate Request Form, Estimate Worksheet
| --
|
| | > Put "a" in A1 and "b" in B1 and save as a CSV file (File, Save and
change
| > the Save As type to CSV).
| >
| > Then open the resulting CSV in Notepad. You should see a,b if your list
| > separator character is a comma.
| >
| > --
| > Jim
| > | > |I apologize for the elementary question. I have an Excel spreadsheet
| > which
| > | is simply a list of email addresses. I want to export them to a format
| > | allowing me to paste them into the "To" field of an email. (In case
| > you're
| > | concerned, this is not unsolicited bulk commercial email). I've been
| > able
| > to
| > | export them to a .csv format, but it doesn't seem to have the commas,
| > which
| > | confuses me and my email software.
| > |
| > | Any help will be much appreciated.
| > |
| > | --
| > | Patty Ayers | www.WebDevBiz.com
| > | Free Articles on the Business of Web Development
| > | Web Design Contract, Estimate Request Form, Estimate Worksheet
| > | --
| > |
| >
| >
|

 

[Patty Ayers]

Yes, and my actual spreadsheet is a small sample: only 1 column and about 15
rows. It comes out without commas, thus my confusion..

 

[Dave Peterson]

Try putting something (a space character or ="") in the adjacent column. Then
save the file as .csv.

You may want to try this technique:

Put this in B1:
=A1

And put this in B2:
=B1&","&A2
and drag down.

You should be able to copy the value in B15 to the email to: field.

 

[Patty Ayers]

Thanks very much, Dave - will try that.

 

[Earl Kiosterud]

Patty,

How are you determining it doesn't have commas? Are you opening it with Notepad or
something like that? If you do, you'll probably see the commas. If you're opening it in
Excel, you won't.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

 

[Jim Rech]

One column of data will not not have a delimiter because there is nothing to
delimit.

 

[timmg]

Yes, and my actual spreadsheet is a small sample: only 1 column and about 15
rows. It comes out without commas, thus my confusion..

Why not highlight the email addresses in Excel then copy and paste
them into the To: or BCC: fields in Outlook. Outlook will do the
necessary conversion to delimit the addressess.

tim mills-groninger