locked
mr RRS feed

  • Question

  • Word enters "0" instead of text in some merged fields:

    I use a spread sheet with a lot of columns with texts and numbers. It used to work well but recently some of the fields in the master letter are replaced by a zero or left blank. The produced merged letter is faulty

    I have looked at the header column format of the spread sheet and master letter. the cells are formatted exactly the same as the working cells

    Sunday, May 29, 2016 8:49 PM

All replies

  • The problem is with your data source, which evidently has mixed data types in the affected column. See Mailmerge Data Format Problems in the Mailmerge Tips and Tricks threads at:
    http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html
    or:
    http://windowssecrets.com/forums/showthread.php/163017-Word-Mailmerge-Tips-amp-Trick

    Cheers
    Paul Edstein
    [MS MVP - Word]

    Sunday, May 29, 2016 10:25 PM
  • Hi A H More complicated,

    it seems that it is word Application issue.

    so I move this thread to Word it pro discussions forum so that you can get better response and better solution to your issue.

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, May 30, 2016 1:51 AM