Scripts

MarcMorgan · 24 Nov 2020

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.

OldNavyGuy · 24 Nov 2020

Since it's not a trivial project, I would suggest you hire someone to do the scripting.

Matthew Wai · 24 Nov 2020

MarcMorgan said:

Email comes into outlook inbox\subfolder

What is the folder path?

MarcMorgan · 24 Nov 2020

It will be Inbox\CustomerBackupReports - Linked via O365

Try3 · 24 Nov 2020

MarcMorgan said:

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.

Marc,

You will need to develop proficiency in VBA [Visual Basic for Applications] or the application of PowerShell scripting to manipulation of MSOffice objects
or
you will need to engage the services of a suitable programmer.

Denis