View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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