I'm a project estimator who prepares schematic design construction estimates
in Excel. I keep a tabbed page called Notes where I record lists of items to
be clarified, subcontractors I've called requesting pricing, etc.

Key contacts such as the architect, the mechanical, structural, and civil
engineers, I keep in Outlook, and I store the project number in their
Category section so that I can fairly quickly lookup any of the phone
numbers. But I'd like to go one step further. Does anyone know how VB could
use the project number from an Excel cell, and retrieve the names and phone
numbers of these consultants automatically?

Thank you.

Sprinks

http://tinyurl.com/7fuly

Might have some ideas

--
Regards,
Tom Ogilvy


"Sprinks" wrote in message
...
I'm a project estimator who prepares schematic design construction
estimates
in Excel. I keep a tabbed page called Notes where I record lists of items
to
be clarified, subcontractors I've called requesting pricing, etc.

Key contacts such as the architect, the mechanical, structural, and civil
engineers, I keep in Outlook, and I store the project number in their
Category section so that I can fairly quickly lookup any of the phone
numbers. But I'd like to go one step further. Does anyone know how VB
could
use the project number from an Excel cell, and retrieve the names and
phone
numbers of these consultants automatically?

Thank you.

Sprinks

Sprinks

With a name like that, you have to be a fire sprinkler guy. Check out this
page

http://www.dicks-clicks.com/excel/olContacts.htm

That should give you the basics of working with contacts. Once you've read
it, come back with any questions and I can help you nail down the details.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Sprinks wrote:
I'm a project estimator who prepares schematic design construction
estimates in Excel. I keep a tabbed page called Notes where I record
lists of items to be clarified, subcontractors I've called requesting
pricing, etc.

Key contacts such as the architect, the mechanical, structural, and
civil engineers, I keep in Outlook, and I store the project number in
their Category section so that I can fairly quickly lookup any of the
phone numbers. But I'd like to go one step further. Does anyone
know how VB could use the project number from an Excel cell, and
retrieve the names and phone numbers of these consultants
automatically?

Thank you.

Sprinks

Tom & Dick,

Thank you both for your suggestions. Exactly what I was looking for.

Sprinks

"Dick Kusleika" wrote:

Sprinks

With a name like that, you have to be a fire sprinkler guy. Check out this
page

http://www.dicks-clicks.com/excel/olContacts.htm

That should give you the basics of working with contacts. Once you've read
it, come back with any questions and I can help you nail down the details.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Sprinks wrote:
I'm a project estimator who prepares schematic design construction
estimates in Excel. I keep a tabbed page called Notes where I record
lists of items to be clarified, subcontractors I've called requesting
pricing, etc.

Key contacts such as the architect, the mechanical, structural, and
civil engineers, I keep in Outlook, and I store the project number in
their Category section so that I can fairly quickly lookup any of the
phone numbers. But I'd like to go one step further. Does anyone
know how VB could use the project number from an Excel cell, and
retrieve the names and phone numbers of these consultants
automatically?

Thank you.

Sprinks