I hope you could accomodate this question, thank you in advance.
I am trying to write a macro code that will email the recipients based on condition. That is, I have different worksheets in a workbook and each is named according to the report name (except the reports recipients sheet because this serves as reference when emailing recipients).
If for example my active worksheet is reportname1, and my macro here will open outlook and email recipients, how can I set the recipients to the values on column B of reports recipients sheet while column A is equal to reportname1 (the active sheet)? Note that I would also like to set column C for Cc field and column D on Bcc field while not empty.
I hope I was able to give clear details, please let me know if otherwise.
Again, thank you.