Email worksheet via command button

Thanks in advance for your time, I'm a new user with a project that is way over my head. I'm very grateful for all help.

I am setting up a request template in an Excel worksheet. Once it has been filled out, the requester will click 'Submit' and, after checking that the required fields are completed, the sheet will be emailed as an attachment either

1 ) to the service desk, if the content of B3 is 'Yes' or, if the content is "No" or Blank,
2) to the email address in D58.

I can't work out how to get the sheet emailed.

This is what I've got so far:

Please Login or Register  to view this content.

(In case you were wondering, the bit that says "address" has the actual email address in it).

Thanks!
KaFi

See http://www.rondebruin.nl/sendmail.htm

Hello Kafi,

This macro is tailored to what you want. Copy this code into a VBA module. Make the changes you need to the recipient address,the message you want to send and the emailed workbook name.

Please Login or Register  to view this content.

Hello KaFi,

Post the code as you have it now. My testing of the macro worked fine. Obviously, something is different.

or

Please Login or Register  to view this content.

Think you need a little more punctuation in that, snb.

Hello KaFi,

I can sort the code out better if you post the workbook.

Hello KaFi,

The problem appears to be we were referencing cell "B3" when we should have been referencing "B53". I made the change. You should also change the default email address in the macro to a real address. Here is the revised macro. I indented the code to make it easier to read. The macro has been added to the attached workbook.

Please Login or Register  to view this content.