Extract Email Addresses & Body into Spreadsheet or Database
Posted on 2013-01-07
Each month our company sends out an email blast to our customers. After every blast, we receive several thousand bounce backs. Any email that bounces back, is acted upon internally one by one. It is such a manual process and I'm looking to stream line this as much as possible.
Ideally, I would love some code that when run - it will extract several things,...
1.) From Email Address
2.) Email Subject
3.) Email Body/Message
A B C
1 email@example.com This is the subject This is the body
2 firstname.lastname@example.org This is the subject This is the body
3 email@example.com This is the subject This is the body
This information will eventually end up in Microsoft Access, but in terms of simplicity - is it possible to get all of that data extracted/copied into a spreadsheet/csv?
I am unable to install any software on my computer, so I believe my only solution is going to be VB related?
I would like this code to run ONLY on a specific folder. The last thing I want is for the code to somehow run on emails that have nothing to do with this project.
Also, my skill level is definitly a beginner. Especially when it comes to any kind of coding.
If you need anymore information, please ask! :)
Thank you in advance for your help!