excel VB to email issues

[cmccabe]

I am almost done with my email VB, but having a couple of issue:

The first is I have a cancel button on a prompt that is supposed to open the VB editor, but currently it does not. I have tried

If vbCancel Then Application.VBE.MainWindow.Visible = True and If vbCancel Then Application.SendKeys "%{F11}", True
Both do not open the editor.

The second issue is I can not seem to figure out is how to email a message from either C2 or D2 to multiple users? I think it has something to do with the offset in bold but I'm not sure. Hopefully, this is almost done and close. Thank you .

VB

Please Login or Register  to view this content.

Thank you .

[Cheetahke]

Hi,

The value you get from the buttons Yes, No and Cancel in a messagebox is an integer. So first of all you need to declare an answer, and use it like this:

Please Login or Register  to view this content.

[cmccabe]

I have made the change and the editor does not open when cancel is clicked. Nothing needs to happen except opening the editor as the cancel button is more for debugging. Thank you .

VB

Please Login or Register  to view this content.