Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2002
    Location
    Kankakee, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel to Word Mail Merge (2003 sp2)

    I am trying to do a mail merge from Excel to Word. No matter how I format a cell in Excel (i.e. 2 digits after decimal point, Currency), Word pulls in an unformated value with multiple digits after the decimal point, or without the $ sign. I have tried to copy and paste special, with value only, but this still does not work. The only way I've ever found around this is to copy and paste the Excel values into a Word table, and then do the mail merge. Please help. I need to be able to make Word and Excel work together better. It never used to do this before we upgraded to the new Office version.

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

    Re: Excel to Word Mail Merge (2003 sp2)

    There are two ways you can solve this using an Excel data source:

    1) Change the way you connect to the Excel file - see <post:=434,784>post 434,784</post:>.

    or

    2) Add a formatting switch to the merge field in Word:
    - Right-click the merge field.
    - Select Toggle Field Codes to display the field code. It will look like
    <code>
    { MERGEFIELD Fieldname }
    </code>
    or
    <code>
    { MERGEFIELD Fieldname * MERGEFORMAT }
    </code>
    - Change it to look like (for example)
    <code>
    { MERGEFIELD Fieldname # "$ #,##0.00" }
    </code>
    - Press F9 to hide the field code and update the field.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel to Word Mail Merge (2003 sp2)

    There is actually a third way, by creating a text copy of the numeric value properly formatted in another cell and merge that cell. For example, if the dollar values are in column B, then insert an empty column C. In C1 enter:

    <code>
    =TEXT(B1,"$ #,##0.00")
    </code>


    Fill this down as far as necessary, then use Column C in the merge instead of B.
    Legare Coleman

Posting Permissions

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