![]() |
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 |
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