Send Email with MsgBox vbOk

[Mordred]

Hi all,

I have a message box with OK and Cancel. I need to have Excel send an email if the user presses ok or to not send if the user presses cancel. I have the code to send emails but I don't know how to apply it to a message box vbOk. I tried the following:

Please Login or Register  to view this content.

but this runs the sendmail no matter which button I press. Please help.

Regards:

[john55]

hi Mordred,
I use this one, try it and see if it helps you

Please Login or Register  to view this content.

[Mordred]

The purpose of this is for feedback from users throughout the corporation. Instead of the code I used in my previous post, is there a way that a New Message from Outlook can be opened with my email and subject already filled?

[tigeravatar]

Mordred,

Here's an example for Ok/Cancel messagebox:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

EDIT: Looks like I should refresh faster, heh

[snb]

Please Login or Register  to view this content.

[Mordred]

Thanks all I really appreciate this but how can the person sending this actually add to the body of the email, if they want to add a message to the email?

[Mordred]

I am going to try and incorporate the Sub from here to hopefully achieve my desired results.

[john55]

using snb's code add

Please Login or Register  to view this content.

[Mordred]

Thanks again everyone!

[snb]

Please Login or Register  to view this content.