Thread: This excel sends email when used with Outlook 200 and 2003 but not2007 can anyone help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
  
Posts: 9,101
Default 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

Reply With QuoteReply With Quote