Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Query
Can anyone let me know what these two lines do in a code?
Set OutMail = Nothing Set OutApp = Nothing Its just that I have a suspition its stopped my send/receive in outlook Many thanks in advance John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Query
Basically, it is clearing down the two object variables. Somewhere
previously the code will have set those objects, but if they are set to nothing before you have finished, that is before the statement OutMail.Send (or maybe OutMail.Display) then you have a problem, if it comes after, that is not the problem. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "JohnUK" wrote in message ... Can anyone let me know what these two lines do in a code? Set OutMail = Nothing Set OutApp = Nothing Its just that I have a suspition its stopped my send/receive in outlook Many thanks in advance John |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Query
All that code does is remove all references from the variable. It i
used to free up memory and should not have anything to do with removin your send/receive. Somewhere above these lines of code there wa probably a line saying something like: Set OutMail = CreateObject("SomeObject") This deletes that reference. -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Query
I think it is more likely to be
Set OutMail = OutApp.CreateItem(olMailItem) or Set OutMail = OutApp.CreateItem(0) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "kkknie " wrote in message ... All that code does is remove all references from the variable. It is used to free up memory and should not have anything to do with removing your send/receive. Somewhere above these lines of code there was probably a line saying something like: Set OutMail = CreateObject("SomeObject") This deletes that reference. K --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Query
Its just that I have a suspition its stopped my
send/receive in outlook Maybe the OP have a problem with this If you look in the Task manager (Ctrl-Alt-Del) and still see Outlook.exe with Outlook closed then look here http://www.rondebruin.nl/sendmail.htm#Introduction See the part about the bug in Outlook -- Regards Ron de Bruin http://www.rondebruin.nl "JohnUK" wrote in message ... Can anyone let me know what these two lines do in a code? Set OutMail = Nothing Set OutApp = Nothing Its just that I have a suspition its stopped my send/receive in outlook Many thanks in advance John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code To Refresh Query Table | Excel Discussion (Misc queries) | |||
QUERY & HELP: so slow executing VBA code... :S | Excel Worksheet Functions | |||
Query on small piece of code | Excel Programming | |||
Code to run an Access query from Excel | Excel Programming | |||
query source code | Excel Programming |