Change Domain in Outlook 2007 Contacts for Faculty and Staff with Exchange Accounts

Export Contacts

1. To transfer your contacts first open Outlook

2. Go to the File menu > and click Import and Export


3. This will open the Import and Export Wizard window

4. Below Choose an action to perform: select Export to File from the list > click Next


5. Below Create a file of type: select Microsoft Excel 97-2003 > click Next


6. Below Select a folder to export from: select the folder in Outlook that contains your contacts

  • This will most likely be labeled as Contacts

7. Click Next


8. Below Save exported file as: click Browse and select where you want your file to be saved, and the name of the file

9. When finished, click Next

10. The next screen will show you what actions will be performed, click Finish


11. Your contacts will be exported to an Excel file

Change Domain Name

All of your contacts, whose email domain is @mscd.edu, will no longer be valid. Do the following to change their domain to the new @msudenver.edu

1. Open the Excel file you exported onto your computer

2. Do the following:

  • Go to the Home tab > Editing group > click the Find & Select button> in the dropdown menu select Replace

  • The Find and Replace dialog box will open

  • Next to Find what: type mscd.edu
  • Next to Replace with: type msudenver.edu

  • Click Replace All

Troubleshooting:

If when your click Replace and Excel does not find any matches for mscd.edu, do the following:

  • In the Find and Replace dialog box, click on the Options button
  • Next to Search: select By Columns

  • This should help Excel to find what you are searching for

3. A window will open informing you of the number of replacements made, click OK


4. Close the Find and Replace window, and Save and close the document

Note: Outlook 2007 cannot import Excel 2007 files, you must save the file as an Excel 97-2003 file.

5. All of your contacts’ domain name will have changed from mscd.edu to msudenver.edu and are ready to be imported into your account

Import Contacts

1. Open Outlook again, and make sure you have closed the Excel file

2. Go to the File menu > and click Import and Export


3. This will open the Import and Export wizard

4. Below Choose an action to perform: select Import from another program or file > click Next


5. Below Select file type to import from: select Microsoft Excel 97-2003 > click Next


6. Below File to import: click on Browse to locate the file where you saved the changes to the contacts

7.  Under Options select Replace duplicates with items imported


8. Click Next

9. Below Select destination folder: select the Contacts folder > click Next

10. The next screen will show you what actions will be performed, click Finish


11. Your contacts will be imported back into Outlook with the new domain name

Change Domain Name for Suggested Contacts

You must change the domain name for your Suggested Contacts list in Outlook as well, to do so follow these steps:

1. Go to the File menu > and click Import and Export


2. This will open the Import and Export Wizard window

3. Below Choose an action to perform: select Export to File from the list > click Next

‌

5. Below Create a file of type: select Microsoft Excel 97-2003 > click Next


6. Below Select a folder to export from: select Suggested Contacts

7. Click Next

8. Below Save exported file as: click Browse and select where you want your file to be saved, and the name of the file

9. When finished, click Next

10. The next screen will show you what actions will be performed, click Finish

11. Your contacts will be exported to an Excel file

12. Follow the same steps for Changing the Domain Name and Importing the Contacts as previously outlined

Final Step

Update your cache to remove old auto-popluated email address

Please click and Download this Script: outlook 2007 Clear Cache (1 KB). It is very important to remove the old email @mscd.edu address from the auto-populate feature of outlook to available undeliverable error messages. This script will remove all email address from the auto-populate feature, but over time with continued use, the database will re-add all of your fequently used contacts.