Re: in which folder can you save a .CSV file?

actually, I got it all figured out I think. I just needed to set up my
Outlook settings, first!

"Gord Dibben" wrote:

I don't know what's going on there.

For sure you saved as an Excel *.xls workbook but get the "cannot access the
file" when you try to open it?

What else is included in the message?

From where are you trying to open the file? From File>Open in a running
instance of Excel or from double-click in Explorer?


Gord

On Sun, 30 Dec 2007 10:49:00 -0800, chivagirl
<chivagirl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I've done as you've suggested and then I try to open the file to resave it
and get the message 'cannot access the file'

"Gord Dibben" wrote:

Ok

From peoplepc you choose to export the address book.

Excel opens and the info gets copied to an Excel work***.

Good so far.

You then go to File>Save As>Save As Type>CSV(comma delimited)*.csv

Give the file a name and "Save".

Now you can't find that *.csv file......is that correct?

Try saving as an Excel workbook into a known folder like My Documents and see if
you can find that.

If you do, open it and re-save as a *.csv to that folder.


Gord

On Sun, 30 Dec 2007 09:46:03 -0800, chivagirl
<chivagirl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have always just used my isp e-mail which is peoplepc. Yes, I've looked at
the help files to see how to export and that obviously isn't much help.
There is just a link to export the address book and when I click on it, it
opens excel and transfers the info to there. But when I try to save it,
there is where I have the original problem.

"Gord Dibben" wrote:

Which email application do you use?

Have you looked at its help files to see how to export your addresses to *.csv
or other?

What has Excel got to do with exporting your address book to a *.csv file?


Gord


On Sat, 29 Dec 2007 13:27:02 -0800, chivagirl
<chivagirl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I am totally unfamiliar working with Outlook, actually. If you could help me
out with that I would appreciate it.

"Gord Dibben" wrote:

There is no "All Files (*.*) " listed under File>Save As>File Type so that is
not strange.

File>Open>Files of Type has the "All Files (*.*) "

To save your email address book as a *.CSV file you must do that though Oulook,
which I assume is your email client.

With Outlook open, File>Import and Export>Export to a File and follow your
nose from there.

If you don't see the CSV extension make sure My Computer>Tools>Folder
Optiuons>View has "show all file extensions" checked.


Gord Dibben MS Excel MVP


On Fri, 28 Dec 2007 07:40:01 -0800, chivagirl
<chivagirl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

okay, your'e not going to believe this but, I tried to do as you suggested
and when I tried to select 'all files', there was no 'all files' listed! Is
that strange or what? Any other suggestions?

"RichardSchollar" wrote:

Hi

Assuming you are doing this from Excel, when you go to the file open
dialog you need to modify the "Files of type" dropdown at the bottom
from "All Microsoft Office Excel Files" to (easiest) "All Files (*.*)"
- this way the csv files will show up listed in the folder.

And yes, you can save csv files to anywhere you can save Excel files.

Hope this helps!

Richard


On Dec 28, 6:22 am, chivagirl <chivag...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
I am trying to save my e-mail addressbook as a .CSV file. When the save menu
opens, it lists a folder under the local disk (C:). But then when I try to
locate the file in order to import the addressbook, I can find no such folder
anywhere. I have tried using other folders unsuccessfully.










.