New
#1
Scripts
Hi All
I hope someone can help or push me in the right direction:
I work for a company that support many external customers across the country - we have control over their backup solutions etc, I need to be able to do the below (i would like to create a script to help save time/effort) - i have no idea and never done scripting before haha
We have several backup solution Products used for different customers ALL which send an email report (xlsx) to a particular email, i would like to be able to complete the below (automated)
Email comes into outlook inbox\subfolder
It exports the xlsx file from the email (moves the email to another subfolder (not as important))
Places the xlsx in a folder on the machine (does this for any email that comes in) - marks/renames file (can be 001/002 etc)
Reads the contents of the spreadsheets (looking for 2 tabs/sheets)
outputs the content to a spreadsheet (that gets created daily (automated if possible)
Basically my overall plan is not to read the emails and open up the files and check each one daily, but rather to open 1 file that pulls all the right information into this file, that way i can just take a look at one spreadhseet and resolve any issues required.