Solved

clean up contacts after migrating from groupwise

Posted on 2007-03-30
2
226 Views
Last Modified: 2010-03-06
We have exported mail boxes to pst files from a groupise server and are importing th pst files into MS Exchange 2003.

This part is all under control

On the old groupwise server, all the users had to add internet: infront of any email going to an external entity.

So all the personal contacts/address books, have entries with for example  internet:raybans@somewhere.com

has anyone got a solution, that we can use to filter out the internet: part on the exchange server as they go out, or a method of removing this tag from the contacts.

yes I have heard of Quest software, but the organisation is a 100 user non profit charity, so I have no budget for software that is not for the ongoing network, and there fore is not an option.

we are using MS Exchange 2003 sp2 enterprise (which was donated)
and outlook 2003 on the desktops.

thanks in advance

Raybans
0
Comment
Question by:Raybans
2 Comments
 
LVL 18

Accepted Solution

by:
Frankco earned 500 total points
ID: 18828496
Hi Raybans,

You can clean up the list by exporting the addresses to an Excel document. This will give you something to work with or at least this will lead you in the right direction.

Export the address to an Excel document. From Exel you can do a find and replace. Type in internet and replace it with nothing. Import the address back into Outlook.

In Outlook, open the address book and choose import/export.
Export to a file and choose Excel
Open the Excel doc and click Find ~ Replace
Type in internet and leave the replace blank.

In Outlook, backup your contacts.
Create a new pst, File ~ Data File Management ~ Add ~ Office Outlook personal folder. Give the folder a name (contacts).
In the Naviation pane click the Folder list button to show all the folders.
In the Navigation pane, select your contacts and choose Copy contacts.
In the popup window select the new pst folder and click okay. You will now have a backup of your contacts incase something goes wrong.
In the orginal contacts folder, delete all the contacts.
Import the contacts from the Excel doc.
Now you have a pst with internet remove from all the address.

cheers,
frankco


0
 
LVL 2

Author Comment

by:Raybans
ID: 18894764
while that works (painfully ) but works

a better solution is using some software transend works a lot better for exporting and importing data.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
To show how to generate a certificate request in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Servers >> Certificates…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question