How to disable Outlook Message while Mailing in a macro?

Hi All,

While mailing through Excel, we get a outlook pop up and if we click yes then only the mail will be sent, i was wondering if we can disbale it or is there any other way by which i can mail through excel without getting messages.

Regards,
Tushar

Hello tushar@excel,

There are 3 ways to suppress the security messages in Outlook.
1) Place all your macros inside an Outlook Add-In.
2) Use Collaboration Data Objects or CDO
3) Use Redemption Data Objects or RDO

For information on using CDO look here Sending Email with CDO
For information on using RDO look here Redemption Data Objects

Sincerely,
Leith Ross

Thanks Leith.

Can you explain how to place the macro in Outlook Add In and use it through excel macro. Since for the first time i am using excel-macro-vba so i am not sure how to achieve it.

Thanks in advance.

Regards,
Tushar

Hello Tushar,

There is no quick and easy answer to your question. This really requires a solid grasp of programming in Windows, and other development languages besides VBA. Outlook Add-Ins can be written using many different tools including Visual Basic 6.0, C++, Visual Java ++, Delphi, Visual Studio .NET and, for Outlook 2003 and later, Visual Studio Tools for Office (VSTO). COM add-ins are the best way to distribute code that you may have originally created or prototyped in Outlook VBA. Visual Studio Tools for Office adds support for managed code add-ins, built with VB.NET and C#, for Outlook 2003 and 2007.

Sincerely,
Leith Ross

Hi Leith,

I am creating a tutorial in excel, in which i am having a simple test, which if user gives then the summary of the test will be sent to the program manager, since i am basically a mainframe programmer, i don't know if there is any better application to achieve it. Since i had a little knowledge about excel, so i went for excel.
But as i have stated earlier, the mail(important part of my project) depends on user conscience which i don't trust. So i wanted a approach which would remove the dependency on the end user.
I tried CDO but probably my firewall setting is avoinding it. I am not sure though. But then in the link it was stated that it can be used without encountering the send error if you have outlook express or windows mail and i have outlook 2003.Then i uncommented the green section and was connected to net yet it gave send error. As for RDO i was not able to use it, reason beyond my comprehension.
So i wanted if i can use outlook add ins. If you have any link where i can know more about outlook add ins it would be og great help. Anyways do you have any idea about any application in which i can design,code my project.

Regards,
Tushar