Feb-25-2018, 10:32 AM
Hi humans & programming birdies!
After 1,5 Python courses on Udemy I would like to start my own little project. But I could use a little help to get going.
In a nutshell: A script to continuously & automatically copy the content of certain received emails in one Excel file in a folder on my desktop. The goal is to present monthly all the content, using that Excel.
A little more in detail:
So there is a devoted Email address, ran out of my outlook. *Certain Emails come in, which contain 6 questions. The information that should be copied to that one Excel is listed below each question.
So the Excel has 9 columns.
1 Ascending number (n=n+1). The number of Emails.
2/7 Column 2 up till 7 are the 6 questions of the Email.
8 Column 8 is the date/time of the Email sent
9 Is the Email address of the sender
The script could be run continuously, as I have a computer which is running 24/7.
*Certain Emails: Perhaps I let people use one tag, so the script recognizes that it should process their email. So perhaps it can look for a tag like ‘catdog123’.
I do not really know exactly where to start. So perhaps somebody can give me an idea of how to approach this challenge, which libraries to use or just give me a start. After a few courses I believe I know quite a bit about the theoretical basics of Python a little. But starting something real life is quiet the challenge.
Thanks a million,
S
After 1,5 Python courses on Udemy I would like to start my own little project. But I could use a little help to get going.
In a nutshell: A script to continuously & automatically copy the content of certain received emails in one Excel file in a folder on my desktop. The goal is to present monthly all the content, using that Excel.
A little more in detail:
So there is a devoted Email address, ran out of my outlook. *Certain Emails come in, which contain 6 questions. The information that should be copied to that one Excel is listed below each question.
So the Excel has 9 columns.
1 Ascending number (n=n+1). The number of Emails.
2/7 Column 2 up till 7 are the 6 questions of the Email.
8 Column 8 is the date/time of the Email sent
9 Is the Email address of the sender
The script could be run continuously, as I have a computer which is running 24/7.
*Certain Emails: Perhaps I let people use one tag, so the script recognizes that it should process their email. So perhaps it can look for a tag like ‘catdog123’.
I do not really know exactly where to start. So perhaps somebody can give me an idea of how to approach this challenge, which libraries to use or just give me a start. After a few courses I believe I know quite a bit about the theoretical basics of Python a little. But starting something real life is quiet the challenge.
Thanks a million,
S