Share via

HOW TO USE MAIL MERGE FIELDS TO REPLACE TEXT WITHIN RECORDS

Anonymous
2018-02-22T00:28:04+00:00

Hello,

Is it possible to use find and replace text with a merge field? Want to insert a merge field where ever a target specific word or character is within  documents in word 2010.

When text replaced the merge field doesn't work and I can't figure out why.

Any tips to get this to work are much appreciated.

Thanks,

Mark

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

Paul Edstein 82,861 Reputation points Volunteer Moderator
2018-02-22T00:37:54+00:00

To replace text with an actual mergefield, select & copy the mergefield to the clipboard, then use Find/Replace to find the text and specify:

^c

as the Replace expression.

Was this answer helpful?

10 people found this answer helpful.
0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-02-22T01:55:06+00:00

    Hello Paul,

    I just realized you are macropod... I've also been trying to do an excel macro to do similar. It's challanging and details are posted here. Don't think it's a quick fix but let me know what you think.

    Here is the link to the post:

    https://answers.microsoft.com/en-us/msoffice/forum/msoffice\_excel-mso\_winother-mso\_2010/how-to-change-targeted-character-using-column/1be77667-940e-43e2-875e-640351752e21?messageId=8b42e2a8-51b2-40fb-85da-43c65e8351b3

    Cheers,

    USAMark

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Doug Robbins - MVP - Office Apps and Services 323K Reputation points MVP Volunteer Moderator
    2018-02-22T02:18:53+00:00

    See my response to that thread.

    Was this answer helpful?

    0 comments
  3. Paul Edstein 82,861 Reputation points Volunteer Moderator
    2018-02-22T02:17:23+00:00

    For what you've described in that post a mailmerge wouldn't be appropriate unless you inserted a NextRecord field before all the mergefield replacements except the first. See my separate reply in that thread.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-02-22T01:46:21+00:00

    Ah So Paul, : ) : ) : )

    I recall seeing / reading that but didn't try it or understand it is or would be that simple. YES! It worked perfect!!!

    Thank You for your quick response to this question and putting the spotlight on it for me. : )

    I appreciate it!

    Cheers,

    USAMark

    Was this answer helpful?

    0 comments