send email by checkbox selection

Hi I have the following code working, it pickups cell values then used them to make an email in outlook.

What I would like to do is tick checkboxes to make a selection so that it can generate emails from only what I have selected. As i will be adding new IT Problems to a sheet and want to inform users of their problem number to tracking issues. How do i do this? thanks

Please Login or Register  to view this content.

Hello Kendals,

Use another macro to examine the state of the check boxes on the active sheet. Attach this macro to a command button (from the Forms toolbar) on the worksheet that has the check boxes. Click the command button when you want to send the emails. Here is the macro to do that. Place this in a Standard VBA module.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hi I tried this but am unable to get it working.
The email code is specific to one row, it needs to pickup the selected rows either by a checkbox or a value for example. I do see what you mean by checking the checkbox states then invoking the sendmail function, but i am unable to what you said working.

Hello Kendals,

I'll post a sample workbook with a few check boxes so you can see how the code works. If the check box is in the same row as the email, it is easy do. You have to be careful of your check box alignment. If it isn't correct, it won't email.

Sincerely,
Leith Ross

thanks, unless you can think of a better way to select them, maybe by entering the number 1 in a cell on each row, the code would pick this up and do the email. As i think the checkbox thing may get messy as the sheet that this code is going into is going to be used alot.

how do i intergrate this in to my code?

Hi i get runtime error 1004, below is the header which is placed above your code, if you run it you will see the error i get. I have a screen shot of my excel sheet above. The vba script works by picking up cell values and putting them in to an email.
thanks

Please Login or Register  to view this content.

Hello Kendals,

The following macro provides your SendEmail macro with error messages for the ShellExecute function. Taking short cuts when using API calls is common, and a bad idea. The API is not forgiving of errors like VBA. Place this code in a Standard VBA module.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

thanks leith. Kerno do you know why i am getting the compile error?
thanks

Can you please add and excel 2003 attachment with working example. I have an excel with checkbox in every row. I want to send email notification with information's from the same row of the check box.