Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Louis
 
Posts: n/a
Default Worksheet to .cvs format

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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
Louis
 
Posts: n/a
Default

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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I format the tabs of a worksheet in Excel? s_e_morin Excel Discussion (Misc queries) 1 June 27th 05 09:08 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
How do I copy a cell (content AND format) from one worksheet to a. Excel Format Copy Excel Worksheet Functions 1 February 9th 05 10:34 PM
How do I change format of all comments in worksheet? Clare Castle Excel Discussion (Misc queries) 1 January 19th 05 03:54 PM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 01:23 PM


All times are GMT +1. The time now is 04:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"