In this article, we have created data consolidation tool to consolidate the data from multiple emails. We have create the excel template also for sales data. Multiple salesman can fill this sales template and send it using Send on Email button in Sales Template. Email will come to a specific outlook folder. We have used outlook rule to move the email on the base of specific word in subject line. This consolidation tool will download the attachments from those emails and will consolidate in to one Excel sheet.
26 Apr 2020
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.https://www.pk-anexcelexpert.com