Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Location
    Durham, North Carolina, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MailMerge from Access (2000)

    I am trying to use Word MailMerge (2002) starting from Access (2000). All fields merge correctly except the currency field. The values come over correctly, but the formatting does not (ie: $1200.00 merges as 1200). The format is correct in the Access table.

    Does anyone have a solution?

    Thanks for your help.

    Steve

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

    Re: MailMerge from Access (2000)

    You can format the merge field in Word:

    - Right click the merge field.
    - Select Toggle Field Codes.
    - Before the closing bracket } insert # "$ #,##0.00"
    - Right click the merge field again.
    - Select Toggle Field Codes.
    - Press F9 to update the field.

Posting Permissions

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