Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Outlook: Changing all contacts to File As Company
- Thread starter mattborn
- Start date
This can be easily fixed by exporting your contacts to an Excel file. Open the file and you'll see all your data with the fields by column and contacts by row. The field names are contained in row 1 of each column.
Before you make any changes add a column and number it sequentially. This will index your data as it was exported. You can resort your contact records when done.
Changing one field at a time, sort by that "Company" field so all populated cells will be together. As long as the destination field (ex. home address) is empty cut and paste the data from "Company" to "Home". This way you will not overwrite data in the "home fields".
After each successful change save the file so if you really screw something up you have not lost any good changes.
For data in both Company and Home fields choose the correct info.
Do this for each field you want to move.
When done resort by the index column you created. Delete the index column and save the file. Finally,import the contacts back into your Outlook client. If everything went well you should see all your contacts "Home"!
This will take less time than you think and should be more accurate than re-keying the info.
Good luck.
David
Before you make any changes add a column and number it sequentially. This will index your data as it was exported. You can resort your contact records when done.
Changing one field at a time, sort by that "Company" field so all populated cells will be together. As long as the destination field (ex. home address) is empty cut and paste the data from "Company" to "Home". This way you will not overwrite data in the "home fields".
After each successful change save the file so if you really screw something up you have not lost any good changes.
For data in both Company and Home fields choose the correct info.
Do this for each field you want to move.
When done resort by the index column you created. Delete the index column and save the file. Finally,import the contacts back into your Outlook client. If everything went well you should see all your contacts "Home"!
This will take less time than you think and should be more accurate than re-keying the info.
Good luck.
David
- Status
Similar threads
- Locked
- Question
- Locked
- Question