combining records

C

Charlie

I have a table of about 300 phone number/names that came off my cell phone.
I want to import them into Outlook, but their not setup up proerly. If "Joe
Doe" has a mobile number, and a work number, then there are 2 records, both
with the name "Joe Doe", but one will have a phone number in the field called
"Cell" and the other will have a number in the field called "work". There
are lots of names like this with 2, 3 even 4 numbers, each in a different
record, having numbers like cell, home, fax, work 2, etc. Can someone
explain how i can combine these so I can import them in Outlook?
thanks,
ck
 
J

John Vinson

I have a table of about 300 phone number/names that came off my cell phone.
I want to import them into Outlook, but their not setup up proerly.
Click to expand...

I would suggest that you ask in one of the Outlook newsgroups. This
newsgroup is for a different program, the database program Microsoft
Access.

Please scroll down the list of newsgroups and find a suitable Outlook
group. You'll get more expert advice there than I can provide!


John W. Vinson[MVP]
 
C

Charlie

Yes, I understand Access is different than Outlook... But if you have a
table where each record denotes a contacts info, you can easily input into
Outlook. So, I was asking this--would someone know of an update query that
would check to see if the name field was the same, and if so combine the
order fields together to one record with that nmae field?
thanks,
ck
 
J

John Vinson

Yes, I understand Access is different than Outlook... But if you have a
table where each record denotes a contacts info, you can easily input into
Outlook. So, I was asking this--would someone know of an update query that
would check to see if the name field was the same, and if so combine the
order fields together to one record with that nmae field?
thanks,
ck
Click to expand...

My apologies. Your original message did not mention using Access as an
intermediary, though it's certainly a good idea.

One concern here: names are NOT unique. I know three people named Fred
Brown; would you want to conflate their records? You should - at the
least - have some other field, such as an email address or phone
number, to distinguish them; even there, two of the Freds are father
and son and at one time lived together (Fred Jr. is now off at
college).

How are your Access table(s) structured? Are you importing these
names/numbers from a text file, or what? Have you used the Find
Duplicates query wizard? If you did wish to combine all the records
for Fred Brown, how do you wish to handle discrepancies (i.e. two
phone numbers - keep both? discard one? or what?)

John W. Vinson[MVP]
 
Top