OK then we may have to do some of this stage by stage. First how to automate word from Access
You will need to go into the VBA Screen to set a reference to use words functionality, so on the Keyboard use ALT + F11 this will open up the VBA screen.
Next Go to the Tools Menu and References, then I would ask you to look down the list and find
Microsoft Word 11.Object Library and tick the box
Microsoft DAO 3.6 and tick the box
Then click close, then go back to Tools and References to see that they are shown at the top of the list.
Next go to the Insert menu and select Insert Module
Then you would type (or copy and paste) in the following:
Function OpenWord()
Dim wrdApp as Word.Application
Set wrdApp=CreateObject("Word.Application")
with wrdApp
.Visible=True
.Documents.Open "Enter the full path and doucment name to open include .doc"
End with
End Function
Save the module and name it as modOpenWord, then close out of the VBA
screen.
The above code will open word and the document you are using for the mail merge.
Next to get this function to work from a button on a form.
Select the forms section and then create a new form in design view
Then from the toolbox select to create a command button.
Cancel the wizard so you only have the button. Then use the right mouse button to open the properties of the button. Then do the following:
Under the tab (at the top) select all, and name the object as cmdOpenWord, change the caption to Open Mail Merge Document
Next go to the Events tab and select On Click to the right you have a small option with 3 full stops, click it and select Event Procedure
In the event type in:
Call OpenWord
Close the VBA screen again and then save the form, change the view of the form and click the button and it will open word and the document.
Once you have done this, please give further information on what you need for your next step.
Good luck
