#1
|
|||
|
|||
Merging phone numbers with + sign
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. |
#2
|
||||
|
||||
What is the format of the data? An Excel file, for example, would record this number as text and there would be no need to use anything other than { MERGEFIELD Mobile }. If we don't know what you are working with it is difficult to suggest how to handle it.
Can you import the data into Excel and use that as the merge data source?
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
So you think it might be the data that the application is exporting may be the problem? I hadn't thought of that. I'll try exporting to an excel file if you think this will give me a more raw data result.
At least this is what I guess you're asking? I personally don't know the format of the data as it's from software that my company uses. I will be back at work monday and can test then. Will post results. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge Formatting Phone numbers | Marie_Melody | Mail Merge | 4 | 07-02-2014 04:22 PM |
can you change department field in phone numbers | pspec | Outlook | 2 | 04-05-2014 02:51 AM |
Converting Phone Numbers Question | certified_techy | Excel | 8 | 06-08-2012 02:27 AM |
Create Custom Labels for Phone numbers | Tonistep | Outlook | 0 | 03-26-2012 02:57 PM |
How to add the plus sign (+) automatically for the numbers which are positive? | Jamal NUMAN | Excel | 2 | 05-01-2011 03:15 PM |