Contact data is in wrong field

[airwrck]

Hi all - I need some help with a complicated problem.

I am working on a PST file that was recovered from some old data.
Unfortunately, the recovery put contact data in the wrong places. Here
are a few examples:

1. Contact street address and city shows up in the "Follup up flag"
field
2. Contact "Email display as" contains the display as information with
the email address, but the email address field is empty
3. Many duplicates of data with slightly different information (Same
contact might have 3 copies, one with a missing telephone number,
another with a missing email address, another with a missing name)

I need to do the following:
1. Get all of the data from the Contact database exported (including
the Followup flag field)
Before you suggest it, yes, I have put the Follow-up flag field in the
Phone List view and copied and pasted it to Excel - unfortunately, the
<cr><lf> in the data prevents the city/state from being entered into
Excel.

2. Sort through the data to consolidate the duplicates (I have a
process that i'm considering, which basically is a series of re-imports
of the data in stages or steps, and having Outlook replace data with
new data on duplicates)

thanks for the help and suggestions.

Eric

 

[Brian Tillman]

Hi all - I need some help with a complicated problem.

I am working on a PST file that was recovered from some old data.
Unfortunately, the recovery put contact data in the wrong places.

How did you "recover"?

I need to do the following:
1. Get all of the data from the Contact database exported (including
the Followup flag field)

There is no "contact database". Contacts, mail, tasks, appointments, etc.
are all kept in the save PST.

Before you suggest it, yes, I have put the Follow-up flag field in the
Phone List view and copied and pasted it to Excel - unfortunately, the
<cr><lf> in the data prevents the city/state from being entered into
Excel.

2. Sort through the data to consolidate the duplicates (I have a
process that i'm considering, which basically is a series of
re-imports of the data in stages or steps, and having Outlook replace
data with new data on duplicates)

If you still have access to the old PST, start Outlook and open that PST
with File>Open>Outlook Data File. All your data should look exactly like it
did when last it worked. Copy the contents from one folder to another, if
you wish.

 

[airwrck]

Brian - thanks for the response. If I had access to the original PST,
I'd do that. I've inherited the file and situation.

I realize there's no "contact database". However, for the intent of
this message, I'm trying to export fields from the Contact folder that
are not normally exported (Follow-up flag and Conversation, for
example) (I actually had success in copying the entire Contact folder,
in Phone List view, with the fields that I want, into a Notepad file to
try to manipulate the fields that I need to fix)

If I can just get every field in every Contact, regardless of what it
is, exported from the Contacts folder into a text document, I could
script, program, or manipulate the data to put it back in the right
place.

Can anyone help me with getting all of that data, every field from
every contact, extracted from Outlook? If I get the field headers too,
that is an even bigger bonus. The predefined "Import and Export..."
utility in Outlook will not suffice.

thanks
Eric