Hi All,
I did an excel macro that will take the server logs from my outlook inbox and populate in excel sheet, in which my subject itself say on what date it ran, what job and the status(PASS/FAIL).Every thing is smooth here. But i wanted to take it further, for the failed emails we get logs either in the body of the email or in a text file. For the logs in the mail body i bought that to the sheet and parsed the particular line of the error message, im trying to bring the content of the file to do the same, but i all i can find is that i can save the attachment to a folder.
Is there any way i can bring the content of the email attachment next to the Body of the message column in excel?
I did an excel macro that will take the server logs from my outlook inbox and populate in excel sheet, in which my subject itself say on what date it ran, what job and the status(PASS/FAIL).Every thing is smooth here. But i wanted to take it further, for the failed emails we get logs either in the body of the email or in a text file. For the logs in the mail body i bought that to the sheet and parsed the particular line of the error message, im trying to bring the content of the file to do the same, but i all i can find is that i can save the attachment to a folder.
Is there any way i can bring the content of the email attachment next to the Body of the message column in excel?