Hermanator
Technical User
Hello all,
I hope that someone likes to help me with this 'problem'. I think that I need to create a macro for this, that's why I have placed this question here. This is what I would like to do:
I would like to create an Excel sheet that can import data from a series of e-mails. In my mail-box, I receive a message every day with stock-quotes. All these mails go into a specific mail folder. As a mail-client, I use Mozilla Thunderbird. This program places all the e-mails of a mail-folder into one text-file.
So the macro needs to read that text file, and then search for a certain word (for example "subject") to locate the start of an e-mail. Then import certain values to the excel sheet, and then move on in the file to the next e-mail, till the end of the file.
Each day, a new e-mail is added to the file, so the number of data to read increases.
Does anyone have a few pointers?
I hope that someone likes to help me with this 'problem'. I think that I need to create a macro for this, that's why I have placed this question here. This is what I would like to do:
I would like to create an Excel sheet that can import data from a series of e-mails. In my mail-box, I receive a message every day with stock-quotes. All these mails go into a specific mail folder. As a mail-client, I use Mozilla Thunderbird. This program places all the e-mails of a mail-folder into one text-file.
So the macro needs to read that text file, and then search for a certain word (for example "subject") to locate the start of an e-mail. Then import certain values to the excel sheet, and then move on in the file to the next e-mail, till the end of the file.
Each day, a new e-mail is added to the file, so the number of data to read increases.
Does anyone have a few pointers?