Mergefield

macropod · #1 06-10-2019, 04:32 PM

Quote:

Originally Posted by boonlailee

Let me show you the result i get so far,

1. Original Result before any amendment: INV-0001
2. Result after amendment as per Paul: INV-0001
3. Result after amendment as per Graham: DO-INV-0001

Either approach, done correctly, will generate DO-0001. I can only conclude you haven't followed the instructions. Without actually seeing the problem mailmerge main document, it can be difficult for anyone to diagnose the issue. Can you attach the mailmerge main document to a post (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

boonlailee · #2 06-10-2019, 05:45 PM

Hi Paul,

thanks for your feedback, refer the attached.

Page 1:
Highlighted in Yellow, this is the original Invoice No based on <<DocNumber>> and required NO transformation. the result is INV-0001 (this one is totally fine).

Page 2:
Highlighted in Green, this is the DO No, to be based on <<DocNumber>> which required transformation we discussed above, the expected result should be DO-0001
and have yet to get the desired outcome.

Thanks again.
Boon Lai

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to populate column with text prefix then next number (ascending)	SerenityNetworks	Excel	4	02-05-2019 07:22 AM
Replace characters in mergefield	tommatwalker	Mail Merge	6	07-17-2018 12:30 AM
Find entries lacking prefix and then add prefix.	gsteel	Excel	2	08-28-2017 11:36 AM
Word 2007 TOC Section Number w/Alpha Prefix?	Gwen Butler	Office	2	09-29-2011 06:10 AM
Find & Replace words with "/" prefix & suffix	tollanarama	Word	4	01-25-2011 02:19 AM