Hi I have an excel file with 5 different tabs that is being updated daily. New row of data is being added to each of the tabs daily.
I need to send out a daily email using the data from two of those tabs. The data will consist of 3 rows (today's data, yesterday's data, and last quarter end data) along with the headers.
I have attached a sample input file i will be pulling data from.
Below is what my email body should look like.
Data# 1 --> (this is the 2nd tab of my excel file)
DATE | column 1 | column 2 | column 3 | column 4 | total | daily Change | QTD Change |
6/30/2022 | 4,141 | 747,474 | 7,788 | 85,685 | 89,826 | 0.21% | 0.00% |
8/9/2022 | 87,878 | 787 | 555,252 | 42,542 | 130,420 | -78.26% | 45.19% |
8/10/2022 | 45,454 | 4,545 | 24,242 | 4,242 | 49,696 | -61.90% | -44.68% |
Data#2 --> (this is the 4th tab of my excel file)
DATE | column 1 | column 2 | column 3 | DoD Change | QTD Change |
6/30/2022 | 45,454 | 212 | 1,254 | 1.83% | 0.00% |
8/9/2022 | 232 | 565 | 5,745 | -92.43% | 358.13% |
8/10/2022 | 966 | 124 | 15,245 | 165.36% | 1115.71% |
Regards,
EMAIL SIGNATURE
Are you asking if this is possible? Is there a specific challenge in the exercise that is troubling you? Are you asking the community to build the workflow for you?
How can we help?
Cheers,
Mark
@MarqueeCrew I am asking how this can be done. As in which tools to use to create a table in automated email. I could not find a way to add a table and pull in specific data from an excel file using the email tool. No, i am not asking the workflow to be built for me. Just to point me in the right direction.