Changing Email Domain for All Contacts In a Company

[Sprinks]

One of our clients recently changed their name. I was able to change the
Company field, but, of course all of their email addresses have changed as
well and didn't see an easy way to do it. As there are over a hundred
contacts at this client, we were considering just importing them into Access,
running an update query, and importing them back.

Does anyone know of an easier way?

Thank you.

Sprinks

 

[Diane Poremsky {MVP}]

there might be a VBA sample at slovaktech.com but I'd probably export to
excel, find and replace them import. (after first moving them to a new
contacts folder so I only export these). I don't know whether access or
excel would be better, but I work in excel more and know where to find
everything.









** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **

 

[Sprinks]

Thanks, Diane.

there might be a VBA sample at slovaktech.com but I'd probably export to
excel, find and replace them import. (after first moving them to a new
contacts folder so I only export these). I don't know whether access or
excel would be better, but I work in excel more and know where to find
everything.









** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **