 |
 | 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 / Excel / Programming / March 2006how to write excel in macros through which mail has to be sent via outlook
Hi, I am not good with macros, i would like to see few examples which can generate e-mails from excel. i have to send the status report to various persons Please help Thanks Sam Hi Sam, Take a look at the excellent site Ron has put together: http://www.rondebruin.nl HTH Carim Hi Carim, I went in to the site, but few functions were not working in my system. Ex: Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem How do i proceed? Thanks Sunil Sunil, Once you are in VB ( Alt F11 command ), in the menu Tools Reference, you will have to tick off the appropriate library ... in your case, it should be Microsoft Outlook Object x.xx Library HTH Cheers Carim Hi Carim, It's already been ticked off, the library name is microsoft outlook 10.0 object library Thank You, Sam go to the VBE, Alt+F11, then go to tools->References and find Microsoft Outlook in the listing. Click the checkbox to create a reference to it. Then Excel will understand those declarations.  SignatureRegards, Tom Ogilvy > Hi Carim, > [quoted text clipped - 7 lines] > Thanks > Sunil Please read the information above the macro examples 1) Go to the VBA editor, Alt -F11 2) Tools>References in the Menu bar 3) Place a Checkmark before Microsoft Outlook ? Object Library ? is the Excel version number SignatureRegards Ron de Bruin http://www.rondebruin.nl > Hi Carim, > [quoted text clipped - 7 lines] > Thanks > Sunil Hi Sam, Look here: http://www.rondebruin.nl/mail/add-in.htm SignatureKind regards, Niek Otten > Hi, > [quoted text clipped - 7 lines] > Thanks > Sam Hi Niek, Yeah! the addin is useful, but still i would like to learn the macros Hope you will help me out... Cheers Sam |
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.