Solved

clean up contacts after migrating from groupwise

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Sometimes Outlook might have problems sending a message. There may be various causes- corrupted PST, AV scanner etc. The message, instead of going to the Sent Items folder, sits in the Outbox indefinitely. To remove it you can use a free tool cal…
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
In this video we show how to create a Resource Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: Navigate to the Recipients >> Resources tab.: "Recipients" is our default selection …

706 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

14 Experts available now in Live!

Get 1:1 Help Now