you have an existing where clause on the recordset:
WHERE OrderProcess = 'NEW' OR OrderProcess = 'Failure' OR OrderProcess = 'Cancelled'
use parenthesis around those clauses:
WHERE (OrderProcess = 'NEW' OR OrderProcess = 'Failure' OR OrderProcess = 'Cancelled')
the existing o clauses are causing ambiguous search term by adding parenthesis, the existing or clauses are processed first, then the email address and clause is performed on that result.