Posted to microsoft.public.excel.programming
|
|
Obtaining Info From MS Outlook
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
|