Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You don't need the Quit Nigel
Setting it to nothing is enough -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Nigel" wrote in message ... Ron, Absolutely right, unchecking the box fixed it, the .Quit method now works OK Cheers Nigel "Ron de Bruin" wrote in message ... Hi Nigel Because there is a bug in Outlook it is possible that you must uncheck "send immediately when connect" in the Outlook options. <ToolsOptionsMail Setup in the Outlook menu Problem : It will not close the Outlook process after the mail is sent in the Task Manager This seems to be fixed in Office 2003 -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Nigel" wrote in message ... Hi All I am using thse following to mail some information from Excel, whether Outlook is currently running or not, I end up wth an instance of Outlook that does not close. Everytime I call this it create another instance. Why? TIA Cheers Nigel Private Sub EMail() Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(olMailItem) With OutMail .To = .Subject = "Test" .Body = "Test" '.Attachments.Add .DeleteAfterSubmit On Error Resume Next .Send End With Set OutMail = Nothing Set OutApp = Nothing End Sub ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I set up Outlook email? | New Users to Excel | |||
message box to print or email when closing workbook | Excel Discussion (Misc queries) | |||
Outlook Email | New Users to Excel | |||
Startup and template locations in Citrix TS session and local session | Setting up and Configuration of Excel | |||
Email & Outlook | Excel Discussion (Misc queries) |