Okay so here is the code that I've been trying to make work to extract data from certain e-mails and put it into a master Excel file:
I have been running into several issues. First is that in order for the script to fill the cells, cell A1 needs to be selected in the Excel doc before I save and close it. The biggest issue comes from when I try to have subsequent e-mails come in. The script stops and the error says "Method 'Rows' of object '_Global' failed." When I run debug it points to the line "iR = oWS.Cells(Rows.Count, 1).End(xlUp).Row + 1" and I am not sure how to modify it so that it will work.
Thanks, you guys are the best!
Bookmarks