Checkbox to trigger email via CDO

I am trying to generate an email message through CDO when a checkbox is marked. Right now I get an error message

Runtim error '-2147220960 (80040220)': The "SendUsing" configuration value is invalid.

I am new to Visual Basic but not to command lines and syntax. This is on a work network. If you want to know more about what I am trying to do see after my code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

In a nutshell, I have a shared spreadsheet (through a shared folder on the network) that will have part orders inputed. If the part is needed ASAP there is a check box. When the box is checked I would like an email sent to me to tell me so. I don't want the user to deal with any prompts or having Outlook open up on them, just a click and go kind of deal.

If I'm going about it wrong let me know what alternatives I have. I would like this done within the week.

Thanks in advance.

I never spent much time on it, but here is the only way I got CDO to work from Excel:

Please Login or Register  to view this content.