CODEWITHSUNDEEP
ms-wordword-fieldfieldcodes
Soraz
Soraz

Reputation: 6746

How do you substring a MERGEFIELD in Word?

This one has me puzzled. It seemed like an easy task, but the solution eludes me: - How do you substring a merge field in a Word template used for mail merging?

For example, I have something like {MERGEFIELD barcodevalue} and I want to extract the first 6 characters as it is at the same time an identifier for something else.

I can find information on how to remove chars to the left of a given position in a numerical field (\x) but not to the right.

Upvotes: 6

Views: 7478

Answers (1)

Dirk Vollmar
Dirk Vollmar

Reputation: 176159

What is the data provider for your mail merge data? If it is an SQL query you could use the substr/substring function of SQL.

Anyway it might be easier to change your source data/query instead of tweaking mailmerge fieldcodes, which seems to be limited.

Upvotes: 3

Related Questions