Share via

Field Code inserts "_x000D_" in Office 2010 (word)

Anonymous
2012-06-06T19:45:12+00:00

When I am merging a mail merge from an excel document I get "_x000D_" inserted after each line of an address field.  I can't work out how to get rid of this!  The excel document which has the mail merge data in it has the address with carriage returns after each line.  I have tried looking at info on field code switches but can't find anything to resolve this problem.  Any ideas gratefully received!

Microsoft 365 and Office | Word | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Doug Robbins - MVP - Office Apps and Services 322.9K Reputation points MVP Volunteer Moderator
    2012-06-06T20:22:12+00:00

    When I am merging a mail merge from an excel document I get "_x000D_" inserted after each line of an address field.  I can't work out how to get rid of this!  The excel document which has the mail merge data in it has the address with carriage returns after each line.  I have tried looking at info on field code switches but can't find anything to resolve this problem.  Any ideas gratefully received!

    What would probably be best would be to have the different elements of the address in different columns of the Excel data source so that there are no carriage returns.

    Another way of overcoming the issue may be to use the Replace facility to replace "_x000D_" with ^l or ^p

    4 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-02-28T13:27:42+00:00

    Save the excel document as 97-2003 format and all will be well

    5 people found this answer helpful.
    0 comments
  2. Anonymous
    2015-01-11T00:56:41+00:00

    I've found that, for whatever reason, simply having the excel file open while doing the mail merge eliminates this issue. And as another poster said, removing line breaks in the cells that are merged will also eliminate the issue.

    2 people found this answer helpful.
    0 comments