Confirm Data Source

[AnnPhil]

I am automating a mail merge with Access to Word. Does anyone know how to stop the Confirm Data Source dialog window from coming up and just except the default (orginal) data source? I have users that do not know they should just click the OK button, some are clicking NO and then I lose the connection because they dont know where the table link is. I dont know what else to do but tell them to always click the Yes button when confirming but not everone listens and then i have to do it all over again.

 

[Moniker]

Instead of using the built-in Mail Merge functionality, you would have to programmatically perform the merge to avoid that message.

 

[AnnPhil]

that what i was afraid of, not a programmer so i guess i will just leave it the way it is for now, thanks