| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to write excel in macros through which mail has to be sent via outlook
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to write excel in macros through which mail has to be sent via outlook
Hi Sam,
Look he http://www.rondebruin.nl/mail/add-in.htm -- Kind regards, Niek Otten "sam" wrote in message oups.com... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to write excel in macros through which mail has to be sent via outlook
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to write excel in macros through which mail has to be sent via outlook
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to write excel in macros through which mail has to be sent
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. -- Regards, Tom Ogilvy "sam" wrote: 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to write excel in macros through which mail has to be sent via outlook
Hi Carim,
It's already been ticked off, the library name is microsoft outlook 10.0 object library Thank You, Sam |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to write excel in macros through which mail has to be sent via outlook
Hi Niek,
Yeah! the addin is useful, but still i would like to learn the macros Hope you will help me out... Cheers Sam |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to write excel in macros through which mail has to be sent via outlook
Please read the information above the macro examples
1) Go to the VBA editor, Alt -F11 2) ToolsReferences in the Menu bar 3) Place a Checkmark before Microsoft Outlook ? Object Library ? is the Excel version number -- Regards Ron de Bruin http://www.rondebruin.nl "sam" wrote in message oups.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| e-mail from excel when outlook is not in use | Excel Discussion (Misc queries) | |||
| How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
| How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
| Display mail application either in Outlook, or Outlook express | Excel Programming | |||
| e-mail macros: MS Outlook | Excel Programming | |||
![sam[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
