Referencing an attached file in a table with VBA?

[A1CLowe]

Hello again,

I have an email function that uses an .oft template however, I want it to reference an attached .oft template in a table. This DB will be sent career field wide for my job so I need it to be as user friendly for those who have no experience working with VBA for ex they wouldn't know how to change the filepath on their own in VBA. Hopefully this is a simple question to answer.

 

[Solo712]

Hello again,

I have an email function that uses an .oft template however, I want it to reference an attached .oft template in a table. This DB will be sent career field wide for my job so I need it to be as user friendly for those who have no experience working with VBA for ex they wouldn't know how to change the filepath on their own in VBA. Hopefully this is a simple question to answer.

You can put the .oft template name in a table without reference to a path. It is your design decision where the template will be placed physically. If you distribute the db with the template you can have it in the same directory with the .mdb/.accdb and then reference it within the VBA code as Application.CurrentProject.path + "\thistemplate.oft". Or you can specify the path to the template in an Access table that holds the database options and parameters if the templates are placed in the same network share or local directory throughout the organization. At any rate, the location of the file should be completely transparent to the user.
Best,
Jiri