Thread: Code Query
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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/