Hello. I am using Access 2003 and Word 2003. From a previous question I have the code below which is opening a Word mail merge document, producting a protected mail merge result, and saving that to a folder/filename. I need to adjust this code so that the folder and filename is referenced from fields in the access database tables. Many account execs will be creating contracts for different clients and I would like those to be saved in specific locations. I'm fairly new to VBA and the integration of Access/Word, so I'd be happiest with code I could cut/past/adjust references. The code below did require me to add the Microsoft Word reference and apply the Microsoft patch http://support.microsoft.com/kb/825765
Private Sub btnMailMergeEarly_Click()
Dim wdApp As Word.Application
Dim wdDoc As Word.Document
Set wdApp = New Word.Application
wdApp.Visible = True
Set wdDoc = wdApp.Documents.Open("P:\Access Database\Contracts\BananaCt.doc")
wdApp.ActiveDocument.Protect wdAllowOnlyReading, , "jsic2633"
wdApp.ActiveDocument.SaveAs "C:\My Documents\Bananas.doc"
Set wdDoc = Nothing
Set wdApp = Nothing