Send Outlook Mail With Signature, Range From Excel and Multiple Email IDs

[Excel Fox]

Not sure why I kept the line like that, but it should be

'Should we display the message before sending?
        If blnShowEmailBodyWithoutSending Then
            .Display
        Else
            .Save
            .Send
        End If

And blnShowEmailBodyWithoutSending should be FALSE

[bandus]

Not sure why I kept the line like that, but it should be

...

And blnShowEmailBodyWithoutSending should be FALSE

Yes, this is exactly what I thought as a solution, but it still shows the message and I have to click on send manually. So in theory it should be working but unfortunately it is not. If you do these modification in your computer does it work? Just to know if something wrong with my system because the code semms completely correct for me.

Thanks for investigating the problem!





https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

[bandus]

I came up with a not so sophisticated solution:
defined the variable as a boolean but not optional, and then gave the False value for it.