locked
Word 2007 getting forms to work with mail merge fields RRS feed

  • Question

  • We set up a form that brings in the mail merge fields(customer details) that then allows the user's to select drop down boxes, check boxes etc, we cannot get this to work in 2007 without changing the form to a normal document and then locking the form. The users aren't very technical and this is a long and laborious task, it worked fine in all other versions of word, please help this is driving me crazy.

    Thanks

    Tuesday, September 14, 2010 8:03 PM

Answers

  • See the following page of fellow MVP Graham Mayor's website:

    http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm

    Note, that to protect a Mail Merge Main Document for filling in Forms, you will need to use a macro containing the following code

    Sub ProtectForm()
    Dim pword As String
    With ActiveDocument
        If .ProtectionType = wdNoProtection Then
            .Protect wdAllowOnlyFormFields, NoReset = True, "password"
            Options.ButtonFieldClicks = 1
        Else
            .Unprotect ("password")
        End If
    End With
    End Sub

    As you can no longer do it via the Developer or Revies tab Protect Document facility.

    -- Hope this helps.

    Doug Robbins - Word MVP,
    dkr[atsymbol]mvps[dot]org
    Posted via the Community Bridge

    "Tomthetrainer" wrote in message news:e08c5e7a-d648-40ad-9399-011a0ef46c1b@communitybridge.codeplex.com...

    We set up a form that brings in the mail merge fields(customer details) that then allows the user's to select drop down boxes, check boxes etc, we cannot get this to work in 2007 without changing the form to a normal document and then locking the form. The users aren't very technical and this is a long and laborious task, it worked fine in all other versions of word, please help this is driving me crazy.

    Thanks


    Doug Robbins - Word MVP dkr[atsymbol]mvps[dot]org
    • Marked as answer by Sally Tang Wednesday, September 15, 2010 6:24 AM
    Tuesday, September 14, 2010 9:48 PM