"Tom Ogilvy" wrote in message
...
Does it run when not executed from a userform? Sounds like your mail
program isn't registered to work with Sendmail.

Although it is n ot something that I ever do, I can send mail from Excel
using Sen dTo. Is SendMail something different (I had assumed not)?

the original poster didn't state that they were having any problem with
the
code. Simply that they wanted to execute it from a commandbutton on a
userform.

No, but it is such a simple next step, I thought the OP had taken it.


xl2003, but I wouln't expect that to be a consideration for this code.

Nor I, but all considerations.