Extract data from emails in Microsoft Outlook
Project detail
I need a VBA code that will extract certain data from an email automatically. The following details have to be extracted from the body of the email:
Sender email address
Date of sending
First Name
Last Name
Job Title
Telephone Number
Company Name
Company Address
Company Zip code
Company City
The emails will be in German, but German language skills are not required. All emails will be in a particular folder in Oulook.
After extracting data, the emails have to be moved to another folder.
1. This has to be a very efficient and stable code.
2. Needs to be coded in VBA – Visual Basic for Applications. (If you feel this can be )
3. The code should run on Windows 10 and with all versions of Microsoft Outlook 2016 and higher.
Please refer to the attached screenshot for more details.