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

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.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
dailytips-subscribe-(E-Mail Removed)

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)

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




"Sprinks" <(E-Mail Removed)> wrote in message
news:6D3D336D-2305-4A56-A9A7-(E-Mail Removed)...
> 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

Thanks, Diane.

"Diane Poremsky {MVP}" wrote:

> 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.
>
> --
> Diane Poremsky [MVP - Outlook]
> Author, Teach Yourself Outlook 2003 in 24 Hours
> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
>
> Outlook Tips by email:
> dailytips-subscribe-(E-Mail Removed)
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
> Subscribe to Exchange Messaging Outlook newsletter:
> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>
> ** Please include your Outlook version, Account type, and Windows Version
> when requesting assistance **
>
>
>
>
> "Sprinks" <(E-Mail Removed)> wrote in message
> news:6D3D336D-2305-4A56-A9A7-(E-Mail Removed)...
> > 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
>