Mail Merge Loses Formatting

Posted on Jan 08, 2009 under xn--zqqs84h3is.com | edit
  • I can't believe something as obvious as retaining the formats from the Excel sheet to the merged Word document isn't part of the programming for these applications!!

    I have read all the help on this topic and tried to use the stupid formatting switches in the field codes to no avail.

    I have a numeric field that I want formatted as a dollar field. I have used "alt f9" to go into the field code and edited as follows:

    {MERGEFIELD"Orig_Prin" # $#,##0.00}

    "Orig_Prin" is a field name from my Excel file. In Excel, the data is formated to appear "$6,000.00", but no matter what I try, it shows up in the merged doc as "6000".

    This makes me so mad, I have spent so much time on it I could have typed all the letters on a manual typewriter by now!! Please help.

    Thanks,

    JPF


  • Try no space after the slash... :)

    http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Mail Merge Loses Formatting , Please add it free.
    Can chinchillas live without hay?
    How can we support an Illinois lawyer with only 2 years experience?