Hi all,

I've done a lot of googling and haven't been able to find someone with this issue.

I'm using a 3rd party application that receives data externally, to mail merge into word fields. One of the fields I'm having issues with is contact number which can come from many sources and as a result have many formats:



+### #### ######
(+###)##### #####
0### #### #####
+###########

... you get the idea. Plus sign's, spaces, brackets... the works...

So the numbers starting with a + are giving me the most grief. I've tried many conditions and I can't seem to get word to handle the merge as a string. It would love to simply tell it to merge it exactly as it appears in my application but no matter what I do I either lose the +### from the start, or if I force the + to appear it I get the last digits only after the spaces.

Let us use this made up number as the example: +61 456 789123

What mail merge code would be required for a field named { MERGEFIELD Mobile }

Final note - before someone suggests me to format all the numbers manually - sadly I cannot, and the quantity I would have to format if I could is too much.