importing e-mail addresses into contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

svandrisse - 20 Oct 2005 04:25 GMT

I exported my contact list into excel and then imported it into outlook 2003.
I did not realize that the e-mail addresses where not in excel. Is there
any I can import the e-mail address into OL 2003 and match them up to the
appropriate contact. What would be the quickest way to enter the appropriate
e-mail address to my contacts?

Reply to this Message

Judy Gleeson MVP - Outlook - 20 Oct 2005 05:07 GMT

Could you explain where the email addresses are at present?

Judy Gleeson - MVP Outlook
Acorn Training and Consulting
Canberra, Australia

see what Outlook training can do to improve productivity:
www.acorntraining.com.au/pdfdocs/ProductivITwithOutlook.pps

www.acorntraining.com.au/productivit.htm

> I exported my contact list into excel and then imported it into outlook 2003.
> I did not realize that the e-mail addresses where not in excel. Is there
> any I can import the e-mail address into OL 2003 and match them up to the
> appropriate contact. What would be the quickest way to enter the appropriate
> e-mail address to my contacts?

Reply to this Message

Brian Tillman - 20 Oct 2005 15:17 GMT

> I exported my contact list into excel and then imported it into
> outlook 2003.

Why?

> I did not realize that the e-mail addresses where not
> in excel. Is there any I can import the e-mail address into OL 2003
> and match them up to the appropriate contact. What would be the
> quickest way to enter the appropriate e-mail address to my contacts?

What did you use to export them? What are you really trying to accomplish?
Were you trying to transfer your items from one version of Outlook to
another?

Signature

Brian Tillman

Reply to this Message

svandrisse - 20 Oct 2005 16:17 GMT

Brian,

Yes I am trying to transfer from one outlook to another. The problem is
that the outlook that I am transferring from is not completely up to date so
if I did another transfer of all contact information I would loose some
contact information from my current outlook files. I am just trying to
extract the e-mail address and match them up with the contacts that I do
have. I am not sure if it is possible.

> > I exported my contact list into excel and then imported it into
> > outlook 2003.
[quoted text clipped - 9 lines]
> Were you trying to transfer your items from one version of Outlook to
> another?

Reply to this Message

Brian Tillman - 20 Oct 2005 20:10 GMT

> Yes I am trying to transfer from one outlook to another. The problem
> is that the outlook that I am transferring from is not completely up
> to date so if I did another transfer of all contact information I
> would loose some contact information from my current outlook files.
> I am just trying to extract the e-mail address and match them up with
> the contacts that I do have. I am not sure if it is possible.

With Outlook closed on the source computer, copy the PST from that PC to the
new PC, place it on the hard disk, remove the read-only attribute if
necessary, and open it on the new PC in Outlook with FiIle>Open>Outlook Data
File. You can then drag-and-drop as you wish from the old PST to the new.

Signature

Brian Tillman

Reply to this Message

Karl Timmermans - 20 Oct 2005 17:24 GMT

If I understand correctly, what you want to do is import another file of
information that contains the email addresses that were not present
originally and "update" existing contacts in your contact folder.

There is no facility to "update" contacts within Outlook's import function.
You would need a 3rd party product (i.e. ContactGenie DataPorter is one -
see link below) or write your own code. What you would need to ensure is
that there is a field (or set of fields) that can be used to specifically
match the contacts in the contact folder to the data contained in the input
data file.

Karl

__________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0
"Power contact importers for MS Outlook '2000/2003"
http://www.contactgenie.com

>I exported my contact list into excel and then imported it into outlook
>2003.
[quoted text clipped - 3 lines]
> appropriate
> e-mail address to my contacts?

Reply to this Message