Hello all,
I have been wondering if there is a way to pull information from an outlook email address and then in automate a spreadsheet from the contents of the email.
So I am in charge of checking email backups of servers and inputting them on a spreadsheet, and every one of the emails either has a success or fail message in the email. It is tedious to go through several vendors/clients emails to see which have passed or failed and to enter the findings manually.
That being said, I am wondering if it is possible to create a macro or If/Then function on excel that says, "If the email in Outlook from a specified email address has the selected server and the word 'success', the spreadsheet would automate a P (Pass) message, whereas a Failure would automate an F."
From a coding standpoint it seems self explanatory, but my macro skills are minimal in excel when sourcing out to other programs.
Thank you for your help/time/any suggestions.
- Trae
I have been wondering if there is a way to pull information from an outlook email address and then in automate a spreadsheet from the contents of the email.
So I am in charge of checking email backups of servers and inputting them on a spreadsheet, and every one of the emails either has a success or fail message in the email. It is tedious to go through several vendors/clients emails to see which have passed or failed and to enter the findings manually.
That being said, I am wondering if it is possible to create a macro or If/Then function on excel that says, "If the email in Outlook from a specified email address has the selected server and the word 'success', the spreadsheet would automate a P (Pass) message, whereas a Failure would automate an F."
From a coding standpoint it seems self explanatory, but my macro skills are minimal in excel when sourcing out to other programs.
Thank you for your help/time/any suggestions.
- Trae
