SendObject

[Steve]

I have a routine that creates a list of e-mails to be sent out, when the list
is completed it then loops through and uses the Docmd.sendObject to send each
mail (Access 2000). This used to work very well and I have not had any
problem with it until about 3 months ago when it started to send the first
mail all ok, out look would ask if it was ok to send and you said yes and it
was sent and so on, but now it sends the first mail all ok and then it just
loops through the rest with no outlook messages or error messages but dos not
send any of the other mails.
This used to work very well about 3 months ago when I was running XP only!
Then it suddenly stoped working.

I am now running my application on WP and Vista home.

My code
DoCmd.SendObject acSendNoObject, , acFormatTXT, StrAddressFull, , ,
StrSubject, strMsg, False

Can any one help with how to fix this Urgent

 

[Daniel Pineault]

Steve,

I do not know the details, but a while back there was another post similar
to your and the response from one of the MVPs was that the sendobject was
unreliable in looped code. Basically it may work and then fail... Basically
not the best approach for looped sequences but rather for one offs.

You may want to look into more reliable alternatives. The various
alternative are listed at

http://www.granite.ab.ca/access/email.htm

Also if you search this forum you may be able to find the post I was talking
about and get more details on the exact nature of the limitation.