Else Without If Issue

[wtucker]

Hello Everyone!

I'm getting an "Else Without If" error on my macro. I'm trying to autogenerate some emails based on the value of the cell H21 in my spreadsheet.
It looks complex because of the outapp and outmail stuff, but it's really just an "if-then, elseif-then, else" statement. Can anyone spot what I'm getting wrong?

Please Login or Register  to view this content.

[leelnich]

Hi wtucker- You can't use a single End With like that. You have to close out each With Block separately, within the IF..Else clause where it's begun.

Please Login or Register  to view this content.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[Winon]

Hello wtucker,

Try your code as shown below:

Please Login or Register  to view this content.

Regards.

[mehmetcik]

You have a "With" with out an "End With" inside you If .... ElseIf statement

[wtucker]

Hi wtucker- You can't use a single End With like that. You have to close out each With Block separately, within the IF..Else clause where it's begun.

So simple. Thank you! I don't know why I couldn't see that.

[xladept]

Hi wtucker,

I "played" with your code a little:

Please Login or Register  to view this content.

[leelnich]

You're most welcome! We ALL overlook the obvious occasionally, that's half the threads on this site! Well, OK, not HALF, but a LOT!
If that answers your original question, please go to Thread Tools up top and mark your thread as SOLVED. Thanks -Lee

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

[bakerman2]

@ Orrin

Also template needs to be of certain plantype.

Please Login or Register  to view this content.