I use Macro Express Pro to automate procedures like that. It's probably do-able with Outlook VBA, but I find Macro Express easier to work with, especially when more than one application is in the mix.



A free, 30-day evaluation copy is available through Macro Express – Macros for your Windows Automation Needs. There are two versions: Macro Express and Macro Express Pro. The two are 90+% the same. Most users won't miss the extra bells-and-whistles of the Pro edition (e.g., supports for Boolean variables). The price difference between the two versions is modest.



I imagine you could make the macro work in any number of ways: For example, perhaps you want to select the email address; or perhaps you want the macro to act on an entire email message or document. Use Macro Express to extract and modify the address via a series of text manipulation statements: If Address Contains "Sprint" then do this, etc.


The macro might place the result in the Clipboard or export it into a text file. You might even be able to place the result in the Outlook address book.


This sounds like a fun scripting project to me!