Why would i want to do this?
Do you want to start a marketing campaign and send it to all of the people you have ever had contact with, where better to start than the peopel you have had email correspondance with. These peopel will all have either sent you and email or recieved one from you. These emails will all be in outlook.
PHP Method
You can configure the script to scan for any variable you want so with a little bit of programming you can scan the emails to see if a customer was interested in certain type og motor bike or wheather he selected certain answers in a survey.
What You Need
- My PHP EML Scraping Script
- XAMPP Web Server
- Outlook Freeware - Export Messages to EML Files (Free registration required)
- Outlook (dohh!!) - (not required for full dump direct from a .pst)
- a full .pst .eml dumper - if you want to dump all emails not just selected one (Optional)
Instructions
These are my instructions on how to scrape emails, Sender Names and other information from emails in your outlook.
My process has a couple of steps and can be configured to grab what information you want.
Overview
- Dump selected emails with outlookfreeware as EML/ Dump all emails as EMLs with {full dumper} in to a folder. This folder should be in the webserver htdocs
- Setup XAMPP webserver
- Increase php timeouts (Optional)
- Create a MySQL database
- Configure my script
- Run My script
- Export data as a .CSV via PHPMyAdmin
Dump Selected Emails
Outlook Export
Unknown to me at the time, outlook has an export feature where you can export selected emails (or folders) to an excel spreadsheet and once there you can perform data manipulation as required.
The location of the Export function varies with each version of office so you need to do a quick google search for Exporting Outlook Emails.
Useful
I would recommend to use ASAP Utilities to perform data manipulation on your Excel Spreadsheets.