Hi Experts,
I'm looking for a vba code that I may reference my concern. I have a workbook that has sheets "Manager 1", "Manager 2" and "Manager 3", and I like to use a macro to send them to different recipients, for example: Sheet "Manager 1" should be sent to "[email protected]", "Manager 2" to "[email protected]" and so on. I've attached my file for your reference.
Thanks!
Bookmarks