Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

clean up contacts after migrating from groupwise

Posted on 2007-03-30
2
Medium Priority
?
234 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Accepted Solution

by:
Frankco earned 1500 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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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…
As much as Microsoft wants to kill off PST file support, just as they tried to do with public folders, there are still times when it is useful or downright necessary to export Exchange mailboxes to PST files. Thankfully, it is still possible to e…
how to add IIS SMTP to handle application/Scanner relays into office 365.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Suggested Courses

618 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