Mail Merge displaying confirm Data Source Dialog
Posted on 2010-09-03
Here's my code for mailmerge- Access 2000 and word 2000
strTestDrive = "Select ID,'MR. ' + Trim(FullName),Address1 as Address1,Address2,Trim(City + chr(44) + State) as CS,Zip FROM TestDrive"
Set wrdapp = CreateObject("Word.Application")
Set worddoc1 = wrdapp.Documents.Add(Template:=myTemplate1, NewTemplate:=False, DocumentType:=0)
worddoc1.MailMerge.OpenDataSource Name:="\\folder\GROUP\\Lunch.mdb", _
LinkToSource:=True, Connection:="TABLE TestDrive", SQLStatement:=strTestDrive
worddoc1.MailMerge.Destination = wdSendToNewDocument
worddoc1.AttachedTemplate.Saved = True
My question is the 'confirm data source dialog box appears as well as the question to select the Table. Is there a way to automate this without the annoying prompts. I expect users not to see those needless prompts.