here is an added twist... wondering if you could help out again @Benzadeus

If olItem.Body = "word" Then
Import into the excel spreadsheet

so essentially - if the email contains a word it will import into the spreadsheet. if it does not, it will not import. The code will still run through all the emails but will only import ones with the body containing a specific word...

any thoughts!?