Link to home
Start Free TrialLog in
Avatar of plq
plqFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Email Address Cleansing in Outlook 2003

What a nightmare. I have to keep maintain 10000 inbox items and 10000 sent items for audit and legal reasons. and growing every day

Lets say I have emails from and to Fred Bloggs. I will have occurrences of all of the following

Fred Bloggs
Bloggs, Fred
'Fred Bloggs'
'Bloggs, Fred'
fbloggs@hotmail.com
Fred Bloggs (fbloggs@hotmail.com)

and so on and so forth.

I need a program that can run through all the emails in each folder and cleanse each address into just Fred Bloggs.

I also need to configure outlook so it uses a consistent format in future. Although I suppose I could rerun the cleanse program periodically.

Any ideas ?
thanks


ASKER CERTIFIED SOLUTION
Avatar of sunray_2003
sunray_2003
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of plq

ASKER

I'd like to read through each email, take each address, normalise it from one of the many possible formats, and rewrite that email record with the corrected normalised address.
Avatar of plq

ASKER

Well you've got so many points another 500 isn't going to make any difference
Avatar of plq

ASKER

:)