I have been using this code to find specific emails in my company Outlook inbox. However, one of the companies we get spreadsheets from has an & in the title like this "Black & White Company: Report" and I'm getting an error (Run-Time error '-2147352567 (80020009)': condition is not valid) when searching for that name. I asked if they could change the & to "and" but they can't change it for legal reasons, since that is the legal name of the company. I have also tried using chr(38) but that also produces the error. I could loop through the inbox but there are hundreds and sometimes thousands of emails and it takes a long, long time. Any suggestions on how to fix this problem? 

Please Login or Register  to view this content.