Best way to send email in loop....SendObject or outlook objects 1

[ToyFox]

I am building a simple loop that emails everyone in a recordset. If I use docmd.sendobject.... the email sits and waits for me to click send....

If I go with outlook objects... with .display .send etc...
the first iteration is fine, but I receive an error on the second pass. I dont have the code now its at home...but which style works better with a recordset and loop to send an email.

 

[PHV]

Set the 9th parameter(EditMessage) of the SendObject method to False

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ToyFox]

WOW, thanks.