Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   taking excel cell info to outlook form & vise versa (http://www.outlookbanter.com/outlook-vba/48328-taking-excel-cell-info-outlook.html)

joe schmo May 15th 07 07:41 PM

taking excel cell info to outlook form & vise versa
 
hi all, What would I use to either get info from a cell in Excel and
populate an outlook form with it (say a date or a number), and then update an
excel sheet from an outlook form as well? Does this make sense? thanks

Sue Mosher [MVP-Outlook] May 20th 07 11:15 PM

taking excel cell info to outlook form & vise versa
 
Use standard Excel methods to open the workbook and read/write the cell. These pages should be helpful:

http://www.outlookcode.com/codedetail.aspx?id=788
http://www.outlookcode.com/article.aspx?ID=38

--
Sue 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

"joe schmo" wrote in message ...
hi all, What would I use to either get info from a cell in Excel and
populate an outlook form with it (say a date or a number), and then update an
excel sheet from an outlook form as well? Does this make sense? thanks



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

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com