Excell linked to outlook contacts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know if it it possible to link a cell in Excell to a contact in
Outlook 2003. I know you can create hyperlinks to web pages or files but I
have people saved in the contacts section of outlook with descryptions of
what they do and procedures they perform. I would like to build a spredsheet
that contains some hyperlinks in cells that would open the contact.

Thanks
David
 
Yes. You can create a VBA procedure and use the COM to access an Outlook object, then assign the macro to the cell, or use a hotkey
and reference the selected cell's contents.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top