HELP MEEE

[jeevanrao]

I have aproblem
I have .csv from my p900 and another .csv from my out look...I want to
merge these two file and get one consolidated contact details!!.
My Problem is in p900.csv it's lists on first name basis and in
outlook.csv it lists on company..I can't seems to get one haevest file
with unique data

You help is really appreciated

 

[Guest]

Your description of your problem is too "generic" for me to be able to offer
specific do-this-do-that help, but once you import the files into Excel, the
data can be manipulated and re-arranged to give you the commonality you
need........The TextToColumns, LEFT, RIGHT, MID, FIND functions among others
will eventually get you there, and if this is something you have to do often,
then all the processes could be rolled into macros.

hth
Vaya con Dios,
Chuck, CABGx3

 

[Ken Wright]

You would generally import them both into Excel regardless of order and then
use something like VLOOKUP to match up the entries from one list to the
other, by pulling all the values from say list B into list A by matching on
a key field.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[kcc]

Outlook is actually very good at reading csv files. During
the import you are given the chance to remap the fields.
Of course this only works if you want the consolidated
list in outlook. I don't know what a p900 is or how to
get data into it.
kcc

 

[jeevanrao]

Yes!!
Sorry about being too Generic.
Let me Explain
I use XP service Pack2 and MS Off Outlook 2003.
The file I got from P900 was.csv file..It has First name, last name, Name,
Company Field, Telephone, Fax, E-mail, web address and SO on..
where in I have data sometime only name and Telephone and Sometime all
Fields
The .csv from Outlook also has same fields and data is complete with
respect to name, Company and e-mail.

But the problem is in the p900 file the list is based on first name and
and in Outlook it's on Company nem
What I'm looking at is
Some kind of macro where it reads same data (Be it first name , telephone
number, company name or E-mail!!)and it puts it in new line and then i can
harvest complete details for Mr Daniel from both my p900 and Outlook .csv

Thank you all for responses..I will try these option mean time!!
Guru