troubleshooting Question

Extract Email Addresses & Body into Spreadsheet or Database

Avatar of Geekamo
GeekamoFlag for United States of America asked on
Microsoft AccessOutlookMicrosoft Excel
20 Comments1 Solution1968 ViewsLast Modified:
Hello Experts!

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

Example Spreadsheet

                           A                                         B                                               C
1        jamesdoe@wow.com               This is the subject             This is the body
2        karendoe@boop.com               This is the subject              This is the body
3        angela@reef.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!

~ Geekamo
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 20 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 20 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros