Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tofolo
 
Posts: n/a
Default 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
  #2   Report Post  
JPW
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Excel database into Outlook Contacts says "No Named Rang Bryan Excel Discussion (Misc queries) 13 December 17th 09 10:23 PM
Using excel to modify a CSV for internatilising outlook contacts Jon Excel Discussion (Misc queries) 1 June 1st 05 08:05 PM
Dates in Excel linked with Outlook Calendar itsupport@cthomes Excel Worksheet Functions 3 May 19th 05 09:12 PM
help with excell to outlook for mail merge gripon Excel Worksheet Functions 2 March 14th 05 05:16 PM
I'm having problems exporting contacts from excel to outlook james Excel Discussion (Misc queries) 2 December 5th 04 07:43 PM


All times are GMT +1. The time now is 11:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"