Please help me to use a Word template from Access VBA

[newboy18]

Please help, I am writing a VBA routine in Access to send emails with 1 of more attachments based on the same Word.Dot template.
The idea is to open the Word template, make some changes and then SaveAs into a temp folder, then when ready email the attachments, clear the folder and then move onto the next contact.
My problem is that I can save the docs but I can’t delete them before moving on to the next contact because the docs are all still open.
I assume there is a way to open a template and then save and close the changed file and still have the template open.
If not it will take forever if I have to keep reopening the template

 

[Rick39]

This may help:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;210271

just remove the portion that closes Word:

'Quit Microsoft Word and release the object variable.
objWord.Quit
Set objWord = Nothing

 

[newboy18]

Thanks Rick,
I do use these commands but they mean I have to reload the Template after saving each doc, what I wanted was to open the Template, Save the changes to a new doc, close the new doc but still have the Template open.
If I can do this it will save loads of time and processing.