Hi, thank you for your suggestions.
I tried all of your suggestion, but still did not get what i desired.

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

Hope you can help to identify where goes wrong please.


thanks again.

Boon Lai

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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

Attached Files

PO_HuxleyFormat_v9_MsForum.docx (126.0 KB, 9 views)