Can I send multiple reports from different source sheets via one message
I want to be able to send multiple reports daily to one individual. I would like this to be in the form of one email, which contains all the tasks/due dates they are associated with that are high priority. The problem is that each report comes from a different sheet, because the columns don't line up from sheet to sheet. Is this possible? If not, is there another way of concisely providing someone with their relevant information from different sheets and reports?