Okay, I am very new to vba. I have done little to nothing when it comes to it. I know what i need done but have no idea how to go about it except for some articles I have come across. My employees get emails when certain batch jobs have been completed, every employee then goes to a piece of paper and checks off the box next to the listed batch job. We want to automate this process. The emails that come in have a subject line saying FTPQ *whatever job name* successful or unsuccessful. Basically i want this email to populate this subject line into an excel sheet that will be saved at end of day on a common drive. Each morning the employees will replace the old sheet with a new blank sheet, same location and same name. If anyone could help or steer me in the right direction I would greatly appreciate it. Thank you!