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