Avoiding Run-Time errors when sending emails from Excel

[BruceJ]

How can I avoid run-time errors when I want to send emails from excel? I a
dialog box is open, I get an error, and I have to exit my userform. The
error message returns all kinds of different numbers.... but almost always
have "A dialog box is open..." This can be any number of dialog boxes. Some
I have no control over, and some I do.

Some sample code would be nice.. I deally, I would like to put a flag in
cell CB of the current row


Thanks
Bruce

 

[Ron de Bruin]

Please more information Bruce

Check out my Mail page first and post back with the exact problems you have.
http://www.rondebruin.nl/sendmail.htm