This excel sends email when used with Outlook 200 and 2003 but not2007 can anyone help
 

Please find the excel sheet loaded at

http://www.4shared.com/file/13504514...ule_ver_1.html


Can anyone help me in getting this done. Outlook closes while i click
button send email.
And it is known its because of me using Outlook 2007.
Thanks
max

This excel sends email when used with Outlook 200 and 2003 but not
 

It is the code at the end

olApp.Quit

'Free objects in memory
Set olApp = Nothing
Set olEmail = Nothing


I think you just have to comment out the last line, but you may have to
comment out all 3 lines. Not sure.

"Max" wrote:

Please find the excel sheet loaded at

http://www.4shared.com/file/13504514...ule_ver_1.html


Can anyone help me in getting this done. Outlook closes while i click
button send email.
And it is known its because of me using Outlook 2007.
Thanks
max