Multiple instances of OutMail in same VBA?

[fourmurphys]

Within the same VBA (excel) module, I have two different places where I send a workbook (different workbooks each time) to different recipients. The first instance runs fine but the second does not. There is no error and the code finishes, but the email is not sent. Thanks for any help identifying which mistake I've made this time... I'm guessing maybe I can't use OutMail more than once??

First instance:

Please Login or Register  to view this content.

Second instance:

Please Login or Register  to view this content.

[AlphaFrog]

You are not seeing an error because of the On Error Resume Next lines. That is considered not good coding practice.

If you sent the first OutMail, create a second Mail item using the Set Outmail line again...

Please Login or Register  to view this content.

[fourmurphys]

Perfect, thank you! Will stop using those On Error lines...