Need help to loop a mailenvelope macro through all worksheets

[shootstill]

I am using this RDB code to send a fixed range to a fixed recipient in the body of an email, but I would like to set it to run for all worksheets.


Any suggestions?

Please Login or Register  to view this content.

[Jack7774]

Try this.

Please Login or Register  to view this content.

[Jack7774]

Did this work for you?

[Jack7774]

If this brought you the desired solution please give rep to those who helped and please mark your thread solved. Thank you.

[shootstill]

I am sorry for the late response - unfortunately, this did not help solve my issue. I have gone another route for handling this need - thank you so much for the feedback.

[Jack7774]

Okay. Thanks for the rep and the response. Please mark the thread as solved when you return. Thanks.