Email 2 CSV Program
The program should connect to a mail box via either pop3 or imap and support SSL - (Essentially needs to support all main email clients and work on a windows machine), All mail server configurations will be picked up from a config file.
When an email arrives the script will read the body message and write the data to a CSV file.
- When writing to a CSV file it should append to it.
- if the file is not there it should create it
- The script should find the CSV output name from an external config file (this can also be a remote location)
- When creating a file it should add headers specified in the the email body
Processing the email
When an email arrives in the mail box the script will process it based on the subject header. Which will be specified in the [url removed, login to view] file
The email will come in the message body will come in the following format
Once the row has been added to the CSV the email is deleted.
Please note if you have a better way to achieve the main goal then please let me know and we can discuss