I've tried pointing it to inbox still nothing.Originally Posted by mancubus
My guess there's some adjustment i need to do with this
[VBA]For Each olMail In olFolder.Items
If InStr(1, olMail.Body, sFilterStart, vbTextCompare) > 0 Then
aExtract = Split(olMail.Body, sFilterStart)
aExtractItems = Split(aExtract(1), " ")
sExtract = aExtractItems(0) & " - " & aExtractItems(2)
If InStr(1, olMail.Body, sFilterStart & sExtract & sFilterEnd, vbTextCompare) <> 0 Then
ActiveSheet.Cells(iRow, 25).Value = sExtract
iRow = iRow + 1
End If
End If
Next olMail
[/VBA]