Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have worksheet that has email addresses in one column. I am trying to make
this list a .vvs format to import into an email program to send an email to all my contacts. I have followed the instructions to save as .cvs format and nothing happens. Can anyone help? |
#2
![]() |
|||
|
|||
![]()
What do you mean "nothing happens"?
Does the file not get saved? What if you save the file in a different format - does something happen then? If the file isn't getting saved, list the steps in "the instructions" you're following... In article , "Louis" wrote: I have worksheet that has email addresses in one column. I am trying to make this list a .vvs format to import into an email program to send an email to all my contacts. I have followed the instructions to save as .cvs format and nothing happens. |
#3
![]() |
|||
|
|||
![]()
I open the worksheet. On the File menu I click Save AS. In the File name box
I type a new name for the worksheet. In the Save as Type list, I click the ..csv format. Then I click Save. When I go to view the new file, I see the same worksheet. When I try to import into Outlook or AOL mail or Webmail on Microsoft Bcentral, there is no information. Now, when I try to import it tells me to MAP the data. I click email address and still nothing occurs. "JE McGimpsey" wrote: What do you mean "nothing happens"? Does the file not get saved? What if you save the file in a different format - does something happen then? If the file isn't getting saved, list the steps in "the instructions" you're following... In article , "Louis" wrote: I have worksheet that has email addresses in one column. I am trying to make this list a .vvs format to import into an email program to send an email to all my contacts. I have followed the instructions to save as .cvs format and nothing happens. |
#4
![]() |
|||
|
|||
![]()
Try viewing the file in NotePad - if you try to reopen it in XL, XL's
parser will attempt to re-parse the data and format it accordingly. In article , "Louis" wrote: I open the worksheet. On the File menu I click Save AS. In the File name box I type a new name for the worksheet. In the Save as Type list, I click the .csv format. Then I click Save. When I go to view the new file, I see the same worksheet. When I try to import into Outlook or AOL mail or Webmail on Microsoft Bcentral, there is no information. Now, when I try to import it tells me to MAP the data. I click email address and still nothing occurs. |
#5
![]() |
|||
|
|||
![]()
Louis,
After you've saved your sheet as csv, open it with Notepad to see what's in it. Set the file type to .csv so Notepad will see it. If you see the data there, separated by commas, the Save as csv has done its job. -- Earl Kiosterud www.smokeylake.com "Louis" wrote in message ... I have worksheet that has email addresses in one column. I am trying to make this list a .vvs format to import into an email program to send an email to all my contacts. I have followed the instructions to save as .cvs format and nothing happens. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I format the tabs of a worksheet in Excel? | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions | |||
How do I change format of all comments in worksheet? | Excel Discussion (Misc queries) | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |