i am trying to figure out how to have an excel file updated every time an email arrives, I would like to have
Sender
Sent time
Subject
Body
in four separate columns. I know this may not be the appropriate forum but I can not seem to figure out how to do this and you guys seem to have the answers to everything. I am using 2010. Any suggestions would be helpful. Thanks!
I found this code on mrexcel, but I haevnt gotten it to work yet, run time error 1004, it opens the excel sheet- the first time it dumped information in one cell but I have not been able to get it to process anything since then.
Bookmarks