Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Oct 2003
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge (Acess 2000)

    I'm using an Access query for a mail merge with Microsoft word.

    The formatting for the telephone number is not going over to word, so I have just a 10 digit number. What can I do to keep the format?

    I've tried to change the properties in the query and it looks fine while in Access. I've even created a make table and then changed the format but it still isn't carrying over to word.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mail Merge (Acess 2000)

    One possibility is to use the Format function in the query:

    Ph: Format([PhoneField],"(000) 000-0000")

    where PhoneField is the name of the phone number field. Another possibility is to leave the query as it is, and format the merge field in Word, by adding a switch to the field code:

    { MERGEFIELD PhoneField # "(000) 000-0000" }

  3. #3
    Star Lounger
    Join Date
    Oct 2003
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (Acess 2000)

    I have it formatted as a telephone in Access and it reverts back to the 10 digit number when merged. I'd like to try adjusting it in Word but don't know how to go about it.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Mail Merge (Acess 2000)

    Word ignores the formatting of the field in the query. You must either use the Format function (not property) in the query, or format the merge field in Word. To do the latter:
    Right-click the telephone number merge field.
    Select Toggle Field Codes.
    You will see something like

    { MERGEFIELD PhoneField }

    where PhoneField is the name of the field (perhaps with a * MergeFormat switch after the field name).
    Insert the following after the field name but before the closing bracket }
    <code>
    # "(000) 000'-'0000"
    </code>
    # is the number format switch, followed by the number format between quotes; the dash is enclosed in single quotes to denote that it's not a minus sign.
    Press F9 to hide field codes and update the field.

  5. #5
    Star Lounger
    Join Date
    Oct 2003
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge (Acess 2000)

    Thank you very much!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •