Good morning,
I have read through various other threads asking this same question but none seem to check all the boxes I'm looking for. I have a workbook that is updated daily using numbers from another workbook. There are roughly twenty sheets and each of these sheets needs to be sent to different people daily. From another thread, I found this website which is very close to what I need, but instead of sending as an excel format, I'd like it as a PDF or text. One difference from the website example is that some sheets have multiple emails that a copy is to be sent to.
Can anyone point me in the right direction? I'm trying to automate this as the current method involves printing the entire workbook and emailing them from a copier.
I have read through various other threads asking this same question but none seem to check all the boxes I'm looking for. I have a workbook that is updated daily using numbers from another workbook. There are roughly twenty sheets and each of these sheets needs to be sent to different people daily. From another thread, I found this website which is very close to what I need, but instead of sending as an excel format, I'd like it as a PDF or text. One difference from the website example is that some sheets have multiple emails that a copy is to be sent to.
Can anyone point me in the right direction? I'm trying to automate this as the current method involves printing the entire workbook and emailing them from a copier.