ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excell linked to outlook contacts (https://www.excelbanter.com/excel-worksheet-functions/32168-excell-linked-outlook-contacts.html)

Tofolo

Excell linked to outlook contacts
 
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

JPW

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.

"Tofolo" wrote in message ...
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





All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com