Outlook 2003 to Outlook Express

ada wrote:

I need help regarding: "create a Personal Address Book in Outlook
and copy your contacts there"
How can I do this?

Now that I go back and try to walk through this for you, it appears there's
no way to reference the PAB from Outlook 2003. The ability of OL 2003 to
access a PAB is read-only; i.e., you can use addresses in an existing PAB so
you can send mail, but you can't write to a PAB to add addresses. The PAB
is viewable only via the Address Book interface and you can't copy items in
that interface. So, exporting to a CSV is your only choice. FIleImport
and ExportExport to a fileComma Separated Values (WIndows).

And where should I put that mailbox.pab (in which folder)?

It wouldn't matter, but it's moot, since PABs in OL 2003 are read-only, it
seems.
--
Brian Tillman [MVP-Outlook]

ada wrote:

I don't know how to examine csv to check is it ok? can I send it to
someone?

Open it either in Notepad or in Excel.
--
Brian Tillman [MVP-Outlook]

ok
I'm back to csv


"Brian Tillman" wrote:

ada wrote:

I need help regarding: "create a Personal Address Book in Outlook
and copy your contacts there"
How can I do this?

Now that I go back and try to walk through this for you, it appears there's
no way to reference the PAB from Outlook 2003. The ability of OL 2003 to
access a PAB is read-only; i.e., you can use addresses in an existing PAB so
you can send mail, but you can't write to a PAB to add addresses. The PAB
is viewable only via the Address Book interface and you can't copy items in
that interface. So, exporting to a CSV is your only choice. FIleImport
and ExportExport to a fileComma Separated Values (WIndows).

And where should I put that mailbox.pab (in which folder)?

It wouldn't matter, but it's moot, since PABs in OL 2003 are read-only, it
seems.
--
Brian Tillman [MVP-Outlook]

I have opened it in Excel and all data (title, first name, middle name...)
are in one column, in column A? Shouldn't it be in each column for every
item/information?


"Brian Tillman" wrote:

ada wrote:

I don't know how to examine csv to check is it ok? can I send it to
someone?

Open it either in Notepad or in Excel.
--
Brian Tillman [MVP-Outlook]

ada wrote:

I have opened it in Excel and all data (title, first name, middle
name...) are in one column, in column A? Shouldn't it be in each
column for every item/information?

If you exported it as a CSV, then Excel will show the data in multiple
columns.
--
Brian Tillman [MVP-Outlook]

unfortunately, no.
all data are in column A separated by comma.

"Brian Tillman" wrote:

ada wrote:

I have opened it in Excel and all data (title, first name, middle
name...) are in one column, in column A? Shouldn't it be in each
column for every item/information?

If you exported it as a CSV, then Excel will show the data in multiple
columns.
--
Brian Tillman [MVP-Outlook]

"ada" wrote in message
...
unfortunately, no.
all data are in column A separated by comma.


select the column then do Data-text To Columns. (Excel 2007 - should be
similar in prior versions). You should be given the option to use comma as
the delimiter. This will translate the single cell data to multi-cell data.

HTH

ada wrote:

unfortunately, no.
all data are in column A separated by comma.

How did you open it in Excel? If you simply double-click on it from Windows
Explorer, does it look any different when it opens?
--
Brian Tillman [MVP-Outlook]