Hi,

How can I use VBA to save details of any of new mail, immediately after receiving, in the first empty row of a specific excel file named "Book1.xlsm", and then save the attachments in this folder:"E:\Mails"

the details that I need are:

1. subject

2.sender name (senders name are saved in contact list) or sender email

3.received date and time

4.hyperlinks to the attachments

Thank you for your help