 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
05-02-2008, 04:57 PM
|
|||
|
|||
|
Export to comma-delimited format doesn't seem to work
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 -- 
|
|
05-02-2008, 05:43 PM
|
|||
|
|||
|
Re: Export to comma-delimited format doesn't seem to work
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 "Patty Ayers" <signup1REMOVE@ayersvirtualREMOVE.com> wrote in message news:u60460GrIHA.4476@TK2MSFTNGP06.phx.gbl... |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 | -- |
|
|
05-02-2008, 05:49 PM
|
|||
|
|||
|
Re: Export to comma-delimited format doesn't seem to work
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 -- "Jim Rech" <jrrech@hotmail.com> wrote in message news:uUs8IOHrIHA.2292@TK2MSFTNGP03.phx.gbl... > 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 > "Patty Ayers" <signup1REMOVE@ayersvirtualREMOVE.com> wrote in message > news:u60460GrIHA.4476@TK2MSFTNGP06.phx.gbl... > |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 > | -- > | > >
|
|
05-02-2008, 06:15 PM
|
|||
|
|||
|
Re: Export to comma-delimited format doesn't seem to work
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 "Patty Ayers" <signup1REMOVE@ayersvirtualREMOVE.com> wrote in message news:e$3gRSHrIHA.4280@TK2MSFTNGP02.phx.gbl... | 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 | -- | | "Jim Rech" <jrrech@hotmail.com> wrote in message | news:uUs8IOHrIHA.2292@TK2MSFTNGP03.phx.gbl... | > 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 | > "Patty Ayers" <signup1REMOVE@ayersvirtualREMOVE.com> wrote in message | > news:u60460GrIHA.4476@TK2MSFTNGP06.phx.gbl... | > |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 | > | -- | > | | > | > |
|
|
05-02-2008, 07:49 PM
|
|||
|
|||
|
Re: Export to comma-delimited format doesn't seem to work
Yes, and my actual spreadsheet is a small sample: only 1 column and about 15
rows. It comes out without commas, thus my confusion.. -- Patty Ayers | www.WebDevBiz.com Free Articles on the Business of Web Development Web Design Contract, Estimate Request Form, Estimate Worksheet -- "Jim Rech" <jrrech@hotmail.com> wrote in message news:Oe4kMgHrIHA.2492@TK2MSFTNGP06.phx.gbl... > 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 > "Patty Ayers" <signup1REMOVE@ayersvirtualREMOVE.com> wrote in message > news:e$3gRSHrIHA.4280@TK2MSFTNGP02.phx.gbl... > | 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 > | -- > | > | "Jim Rech" <jrrech@hotmail.com> wrote in message > | news:uUs8IOHrIHA.2292@TK2MSFTNGP03.phx.gbl... > | > 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 > | > "Patty Ayers" <signup1REMOVE@ayersvirtualREMOVE.com> wrote in message > | > news:u60460GrIHA.4476@TK2MSFTNGP06.phx.gbl... > | > |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 > | > | -- > | > | > | > > | > > | > >
|
|
05-02-2008, 08:04 PM
|
|||
|
|||
|
Re: Export to comma-delimited format doesn't seem to work
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 wrote: > > 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 > -- -- Dave Peterson
|
|
05-02-2008, 08:22 PM
|
|||
|
|||
|
Re: Export to comma-delimited format doesn't seem to work
Thanks very much, Dave - will try that.
-- Patty Ayers | www.WebDevBiz.com Free Articles on the Business of Web Development Web Design Contract, Estimate Request Form, Estimate Worksheet -- "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message news:481B65BC.4BB79B9@verizonXSPAM.net... > 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 wrote: >> >> 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 >> -- > > -- > > Dave Peterson
|
|
05-03-2008, 04:06 AM
|
|||
|
|||
|
Re: Export to comma-delimited format doesn't seem to work
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 ----------------------------------------------------------------------- "Patty Ayers" <signup1REMOVE@ayersvirtualREMOVE.com> wrote in message news:eYVYLVIrIHA.548@TK2MSFTNGP06.phx.gbl... > Yes, and my actual spreadsheet is a small sample: only 1 column and about 15 rows. It > comes out without commas, thus my confusion.. > > > -- > Patty Ayers | www.WebDevBiz.com > Free Articles on the Business of Web Development > Web Design Contract, Estimate Request Form, Estimate Worksheet > -- > > "Jim Rech" <jrrech@hotmail.com> wrote in message > news:Oe4kMgHrIHA.2492@TK2MSFTNGP06.phx.gbl... >> 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 >> "Patty Ayers" <signup1REMOVE@ayersvirtualREMOVE.com> wrote in message >> news:e$3gRSHrIHA.4280@TK2MSFTNGP02.phx.gbl... >> | 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 >> | -- >> | >> | "Jim Rech" <jrrech@hotmail.com> wrote in message >> | news:uUs8IOHrIHA.2292@TK2MSFTNGP03.phx.gbl... >> | > 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 >> | > "Patty Ayers" <signup1REMOVE@ayersvirtualREMOVE.com> wrote in message >> | > news:u60460GrIHA.4476@TK2MSFTNGP06.phx.gbl... >> | > |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 >> | > | -- >> | > | >> | > >> | > >> | >> >> >
|
|
05-03-2008, 02:49 PM
|
|||
|
|||
|
Re: Export to comma-delimited format doesn't seem to work
One column of data will not not have a delimiter because there is nothing to
delimit. -- Jim "Patty Ayers" <signup1REMOVE@ayersvirtualREMOVE.com> wrote in message news:eYVYLVIrIHA.548@TK2MSFTNGP06.phx.gbl... > Yes, and my actual spreadsheet is a small sample: only 1 column and about > 15 rows. It comes out without commas, thus my confusion.. > > > -- > Patty Ayers | www.WebDevBiz.com > Free Articles on the Business of Web Development > Web Design Contract, Estimate Request Form, Estimate Worksheet > -- > > "Jim Rech" <jrrech@hotmail.com> wrote in message > news:Oe4kMgHrIHA.2492@TK2MSFTNGP06.phx.gbl... >> 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 >> "Patty Ayers" <signup1REMOVE@ayersvirtualREMOVE.com> wrote in message >> news:e$3gRSHrIHA.4280@TK2MSFTNGP02.phx.gbl... >> | 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 >> | -- >> | >> | "Jim Rech" <jrrech@hotmail.com> wrote in message >> | news:uUs8IOHrIHA.2292@TK2MSFTNGP03.phx.gbl... >> | > 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 >> | > "Patty Ayers" <signup1REMOVE@ayersvirtualREMOVE.com> wrote in message >> | > news:u60460GrIHA.4476@TK2MSFTNGP06.phx.gbl... >> | > |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 >> | > | -- >> | > | >> | > >> | > >> | >> >> >
|
|
05-05-2008, 03:27 PM
|
|||
|
|||
|
Re: Export to comma-delimited format doesn't seem to work
On May 2, 1:49*pm, "Patty Ayers"
<signup1REM...@ayersvirtualREMOVE.com> wrote: > 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
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
