Brandi, certainly what you want is possible. But I am still not clear.

Is your goal simply to create a file that is linked to an Access and won't pester the user for the data source?

OR

Is your goal to create an automated process that will perform a mail merge using a template and an Access table?

Also, you keep saying you are "opening" a template. Are your really opening a template?