Home All Groups Group Topic Archive Search About

Exporting contacts in a csv file

Author
19 Nov 2007 8:33 PM
cinnamngrl
I am a mysterious problem exporting my contacts as csv file.  The
resulting file has only 58 contacts out of almost 1200 contacts in my
outlook.  These contacts appear to be the last 58 contacts added.  (I
say appear because the attribute "createdon" is not exported so I
can't be exact.  Why is this?

Author
20 Nov 2007 12:45 PM
Brian Tillman
cinnamngrl <cinnamn***@gmail.com> wrote:

> I am a mysterious problem exporting my contacts as csv file.  The
> resulting file has only 58 contacts out of almost 1200 contacts in my
> outlook.  These contacts appear to be the last 58 contacts added.  (I
> say appear because the attribute "createdon" is not exported so I
> can't be exact.  Why is this?

What version of Outlook?  How are you trying to export (exact steps)?  Are
the 1200 contacts all in a single Contacts folder?  Are you storing your
contacts in a PST or on an Exchange server?
--
Brian Tillman [MVP-Outlook]
Author
21 Nov 2007 2:35 PM
cinnamngrl
Show quote
On Nov 20, 7:45 am, "Brian Tillman" <tillman1***@yahoo.com> wrote:
> cinnamngrl<cinnamn***@gmail.com> wrote:
> > I am a mysterious problem exporting my contacts as csv file.  The
> > resulting file has only 58 contacts out of almost 1200 contacts in my
> > outlook.  These contacts appear to be the last 58 contacts added.  (I
> > say appear because the attribute "createdon" is not exported so I
> > can't be exact.  Why is this?
>
> What version of Outlook?  How are you trying to export (exact steps)?  Are
> the 1200 contacts all in a single Contacts folder?  Are you storing your
> contacts in a PST or on an Exchange server?
> --
> Brian Tillman [MVP-Outlook]

> 1. outlook 2000
>
> 2. import/export menu
> a.  export to a file
> b.  Comma Separated Values (Windows)
> c. Select Contacts folder
> d. save exported file as C:\Documents and Settings\xxx.xxx\My
> Documents
> \ contacts nov 20 2007.csv
> e. map custom fields choose default map
> f. export
>
> 3. pst
>
> I tried it again today and found that it exported 59 contacts which
> was the same 58 as yesterday and one that I added today.
Author
21 Nov 2007 7:44 PM
Brian Tillman
cinnamngrl <cinnamn***@gmail.com> wrote:

> I tried it again today and found that it exported 59 contacts which
> was the same 58 as yesterday and one that I added today.

But you don't say if those 1,200 contacts are all in the same Contacts
folder.  If you open the CSV file in Excel, how many entries do you see?
--
Brian Tillman [MVP-Outlook]
Author
21 Nov 2007 10:20 PM
cinnamngrl
On Nov 21, 2:44 pm, "Brian Tillman" <tillman1***@yahoo.com> wrote:
> cinnamngrl<cinnamn***@gmail.com> wrote:
> > I tried it again today and found that it exported 59 contacts which
> > was the same 58 as yesterday and one that I added today.
>
> But you don't say if those 1,200 contacts are all in the same Contacts
> folder.  If you open the CSV file in Excel, how many entries do you see?
> --
> Brian Tillman [MVP-Outlook]

they are all in the same contacts folder.
When I open it in excel i see 59 contacts.
Author
23 Nov 2007 7:18 PM
Brian Tillman
cinnamngrl <cinnamn***@gmail.com> wrote:

> they are all in the same contacts folder.
> When I open it in excel i see 59 contacts.

Do all 1,200 contacts have properlyu formatted File As fields?  Is there
ANYTHING about the ones that don't import that looks different from the 59
that do?  If you open one that doesn't export, how does the entry look
compared to one that does?  Are all the fields defined?
--
Brian Tillman [MVP-Outlook]
Author
23 Nov 2007 9:51 PM
cinnamngrl
On Nov 23, 12:18 pm, "Brian Tillman" <tillman1***@yahoo.com> wrote:
> cinnamngrl <cinnamn***@gmail.com> wrote:
> > they are all in the same contacts folder.
> > When I open it in excel i see 59 contacts.
>
> Do all 1,200 contacts have properlyu formatted File As fields?  Is there
> ANYTHING about the ones that don't import that looks different from the 59
> that do?  If you open one that doesn't export, how does the entry look
> compared to one that does?  Are all the fields defined?
> --
> Brian Tillman [MVP-Outlook]

The clearest difference that I can see is that these are last 59
contacts that I have added to my outlook.
Author
24 Nov 2007 5:12 PM
Brian Tillman
cinnamngrl <cinnamn***@gmail.com> wrote:

> The clearest difference that I can see is that these are last 59
> contacts that I have added to my outlook.

Try changing one of the earlier contcts in some way, perhaps by doing no
more than changing one character in the contacts name to itself (i.e., erase
a character and then type it again).  Save that contact and see if it
appears in an export.
--
Brian Tillman [MVP-Outlook]

AddThis Social Bookmark Button