 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Calendaring / May 2007linking cells in excel to outlook calender
Thanks to all who respond ... in advance. I need to link cells in excel containing completion dates for projects to my outlook calender and then generate alerts to my team members. This is a US government office in Kabul, Afghanistan connected to an exchange server. All help and advice is welcome. No such linkage is built into either program. You would need to write code to handle all the linking you want to accomplish, for example, VBA code in the worksheet to generate email alert messages.  SignatureSue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > Thanks to all who respond ... in advance. > I need to link cells in excel containing completion dates for projects to my > outlook calender and then generate alerts to my team members. This is a US > government office in Kabul, Afghanistan connected to an exchange server. All > help and advice is welcome. Thanks Sue, I suspected as much. I have talked to our IT folks but they are reluctant to write the necessary links, security issues etc. I am trying to convert my team to MS Project where I believe this can be done. Appreciate your time. > No such linkage is built into either program. You would need to write code to handle all the linking you want to accomplish, for example, VBA code in the worksheet to generate email alert messages. > > Thanks to all who respond ... in advance. > > I need to link cells in excel containing completion dates for projects to my > > outlook calender and then generate alerts to my team members. This is a US > > government office in Kabul, Afghanistan connected to an exchange server. All > > help and advice is welcome. Yes, Project does have some linkages built in, but I haven't worked with it myself, though. SignatureSue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx > Thanks Sue, I suspected as much. I have talked to our IT folks but they are > reluctant to write the necessary links, security issues etc. I am trying to > convert my team to MS Project where I believe this can be done. Appreciate > your time. > >> No such linkage is built into either program. You would need to write code to handle all the linking you want to accomplish, for example, VBA code in the worksheet to generate email alert messages. >> >> > Thanks to all who respond ... in advance. >> > I need to link cells in excel containing completion dates for projects to my >> > outlook calender and then generate alerts to my team members. This is a US >> > government office in Kabul, Afghanistan connected to an exchange server. All >> > help and advice is welcome. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.