Contact Folder

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nettiedec - 03 Jun 2006 19:01 GMT

Export Contacts to an Excel Spreadsheet to clean up, Imported back into
contacts in Outlook. No email addresses transferred back in. They are still
in the Excel Spreadsheet.

Reply to this Message

Russ Valentine [MVP-Outlook] - 03 Jun 2006 19:32 GMT

No one can help you when you post no information. There are countless
references in the KB and elsewhere on how to import from Excel. Read them.
Tell us what you did and compare it to what you should have done. Then tell
us what happened.
Start here:
http://support.microsoft.com/kb/295664/en-us

Signature

Russ Valentine
[MVP-Outlook]

> Export Contacts to an Excel Spreadsheet to clean up, Imported back into
> contacts in Outlook. No email addresses transferred back in. They are
> still
> in the Excel Spreadsheet.

Reply to this Message

Nettiedec - 03 Jun 2006 22:28 GMT

Yes I read the KB articles, F1 and onlline help, also I have the 2003 Outlook
QUE Book;
then I
Followed the procedure in Outlook:
Opened Contacts Folder
File>Export>Excel
Exported the Contacts to Contactsjun06.xls
Because the file has many columns, used the Split Windows feature to match
names with email addresses. Did not move columns around, but did enlarge
columns to read them.
Removed duplicate entries
Removed entries with no e mail addresses attached
Un Split Windows feature
Saved the Excel file.
Went back to OutLook Contacts Folder
File>Import>Excel spreadsheet Contactsjun06.xls
File imported
Checked names and emails, no e mails transferred back into Contact Folders,
Only transfered: Last Name, First Name, Company, Addresses, phone numbers,
and that is it.
Then I did a detect and repair for Outlook and did the same procedure again,
and it still did not work. I am using XP Home edition and XP Office Pro 2003.

> No one can help you when you post no information. There are countless
> references in the KB and elsewhere on how to import from Excel. Read them.
[quoted text clipped - 6 lines]
> > still
> > in the Excel Spreadsheet.

Reply to this Message

Russ Valentine [MVP-Outlook] - 03 Jun 2006 22:43 GMT

You obviously did not read the article I posted. Which ones did you read? We
still have no way of knowing.
At what point did you name a range in Excel and map your fields? Both would
have been required to import directly from an Excel file.
http://support.microsoft.com/kb/196743/en-us

Signature

Russ Valentine
[MVP-Outlook]

> Yes I read the KB articles, F1 and onlline help, also I have the 2003
> Outlook
[quoted text clipped - 35 lines]
>> > still
>> > in the Excel Spreadsheet.

Reply to this Message

Nettiedec - 04 Jun 2006 02:15 GMT

Did NOT work did it three times. E mail address refuses to update.

> You obviously did not read the article I posted. Which ones did you read? We
> still have no way of knowing.
[quoted text clipped - 40 lines]
> >> > still
> >> > in the Excel Spreadsheet.

Reply to this Message

Russ Valentine [MVP-Outlook] - 04 Jun 2006 03:23 GMT

You have posted no information once again. You're on your own. Good luck.

Signature

Russ Valentine
[MVP-Outlook]

> Did NOT work did it three times. E mail address refuses to update.
>
[quoted text clipped - 50 lines]
>> >> > still
>> >> > in the Excel Spreadsheet.

Reply to this Message