I have read the Email using IMAP and downloaded the attachments to a folder. Now I need to store every unread mail data’s to an Excel file.
The Excel file should be created automatically every day depending on the date and also wanted to write the email info like Email ID, Received time and Subject to each separate column in the Excel file. For every new email, the data’s should be entered into a new row. If I’m getting 50 emails today, all the 50 emails info should be saved in the excel.
Please help me in this. Thanks in advance.