Opening a document with VBA

[jamtay317]

Hello I am new to this site, and thank you for taking the time to read this! I am working on an Access database, when I Push a button the goal is for for it to open a document that I have already set up with Mail Merge. When I push the button it opens the document, but I cannot scroll between the different records.

Here is the code that I've already created.

    Private Sub cbFESOP_Click()
    Dim wrd As Word.Application
    Set wrd = CreateObject("Word.Application")
    Dim doc As Word.Document
    Set doc = wrd.Documents.Open("Y:\Reports\FESOP Certification.docx")
    
    wrd.Visible = True
End Sub

any and all help will be appreciated thank you!

[macropod]

Your code has nothing to indicate that you're actually trying to merge anything. For code to do that, see, for example 'Send Mailmerge Output to Individual Files' in: https://www.msofficeforums.com/mail-...ps-tricks.html