Thread: CDO Query
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
n_s_simpson[_11_] n_s_simpson[_11_] is offline
external usenet poster
 
Posts: 1
Default CDO Query


Hi people

My program seems to be working ok but one query is that when using CD
it seems to free up Excel before it's completed the subroutine.

This is a problem because I have a cancel button on my form which end
the program before it's sent the emails.

Should it be doing this? I have got an idea of how to stop this issu
but want to make sure that it's supposed to do this first.

Also any idea how long it should take for CDO to send each email?

Thanks

Nic

--
n_s_simpso
-----------------------------------------------------------------------
n_s_simpson's Profile: http://www.excelforum.com/member.php...fo&userid=3185
View this thread: http://www.excelforum.com/showthread.php?threadid=51818