Contacts - Multiple office locations

[Guest]

I have a contact list of vendors all over the country. Many have multiple
locations. What's the best way to reference several locations for one
contact? I'd like to be able to pull up a company name, and show contact
info for various locations. It would be nice to be able to create a drop
down list that has the various cities (read from the address field), and when
you click on a particular city all the contact info for that city comes up,
i.e., phone, fax, e-mail, contact, etc.

I've created some basic forms, but need some general information about the
best way to do this.

Thanks.

 

[Hollis Paul]

I have a contact list of vendors all over the country. Many have multiple
locations. What's the best way to reference several locations for one
contact? I'd like to be able to pull up a company name, and show contact
info for various locations. It would be nice to be able to create a drop
down list that has the various cities (read from the address field), and when
you click on a particular city all the contact info for that city comes up,
i.e., phone, fax, e-mail, contact, etc.

I've created some basic forms, but need some general information about the
best way to do this.

It is amazing how many times the wheel is re-invented. Look at the following
item:

select a specific contact from all contacts.

the custom form allows the selection of a specific contact from all the items
for a company in the contact folder. also attached is a text file that describes
how it might be set up in a folder, and then presents a brief functional
description of the various subroutines.

http://www.outlookexchange.com/articles/home/outlookcodeexample.asp#33

A word of caution. This was created for a much earlier Outlook, and I am not
sure that all of the code will run as it is in Outlook 2003. But, at least, it
will give you an outline of what you need to do.