Avoiding Run-Time errors when sending emails from Excel
 

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

Avoiding Run-Time errors when sending emails from Excel
 

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

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"BruceJ" wrote in message news:3fQrb.116605$mZ5.787734@attbi_s54...
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