Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2004
    Location
    Ohio, USA
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge Problem (MS Word 2002)

    I have a document created in excel with calculated fields (to calculate bonus percentages). When I mail merge into word, using numeric picture switches, everything looks good, except for the fields that had percentages in them (in excel is 102.04% comes out in word as 1.0204, or not a all instead of 102.04). I am not sure what I am doing wrong. <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Mail Merge Problem (MS Word 2002)

    I don't merge from Excel to Word, but I have seen a few threads here on the board that explain how to carry over certain kinds of formatting from Excel to Word during a merge. (In this case, the value is correct, 1.02 = 102%, but the format is being lost). The trick seems to involve connecting to your Excel workbook using DDE. If you search for threads mentioning merge, Excel and DDE, hopefully you will find a quick answer.

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail Merge Problem (MS Word 2002)

    As Jefferson said, you must use the Select method & use DDE when merging from Excel. To keep the formatting from Excel, press Alt+F9 in your main document to see field codes. You'll see something like

    {MERGEFIELD Data1 } or something similar. Delete the Word "MERGEFIELD" from each mergefield, select everything (Ctrl+A), & update the fields (F9). Word should then use the formatting from Excel. However, it may be that Excel is storing it's values just as you see them. In that case, you'll have to use a numeric picture switch like

    # "##.##%"

Posting Permissions

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