Solved

clean up contacts after migrating from groupwise

Posted on 2007-03-30
2
224 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
If you don't know how to downgrade, my instructions below should be helpful.
The basic steps you have just learned will be implemented in this video. The basic steps are shown to configure an Exchange DAG in a live working Exchange Server Environment and manage the same (Exchange Server 2010 Software is used in a Windows Ser…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

919 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now