[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

clean up contacts after migrating from groupwise

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
Raybans
Asked:
Raybans
1 Solution
 
FrankcoCommented:
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
 
RaybansAuthor Commented:
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

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now