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)" & ""

'Open the Datasource
wrdDoc.MailMerge.OpenDataSource Name:="data.xls", _
ConfirmConversions:=False, LinkToSource:=True, ReadOnly:=True, _
Format:=wdOpenFormatAuto, Connection:="Computer Data", _ SQLStatement:="", SQLStatement1:=""

'Setup Mail Merge
With wrdDoc.MailMerge
With .DataSource
.QueryString = tSql
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Destination = wdSendToPrinter
.MailAsAttachment = False
.MailAddressFieldName = ""
.MailSubject = ""
.SuppressBlankLines = True
.Execute Pause:=True
End With

Thanks for the help

Tainter