| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sending Email from within Excel 2003 using Outlook 2003 | Excel Discussion (Misc queries) | |||
| email worksheet from Excel 2003 using Outlook 2007 | Excel Discussion (Misc queries) | |||
| Exporting email from Outlook to Excel 2003 | Excel Discussion (Misc queries) | |||
| email from excel 2003 is not sent unless outlook 2003 is open | Excel Discussion (Misc queries) | |||
| Macro sends Excel file by Outlook - works in debug - not realt | Excel Programming | |||
![Max[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
