Ok so from one problem to the other. So my query searches for records that dont have an X in the field or null. So when I run my mail merge it gives 1 record which is right...but it prints all other record with blank data. The only data I want to run is where an "X" is in the BatchRan field!
Here is the SQL statement
tSql = "SELECT * FROM data.xls WHERE (BatchRan Is Null)" & ""