Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-23-2019, 07:04 PM
WibbleWobble WibbleWobble is offline Merging phone numbers with + sign Windows 10 Merging phone numbers with + sign Office 2016
Novice
Merging phone numbers with + sign
 
Join Date: Dec 2019
Posts: 2
WibbleWobble is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 12-28-2019, 03:10 AM
gmayor's Avatar
gmayor gmayor is offline Merging phone numbers with + sign Windows 10 Merging phone numbers with + sign Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

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
Reply With Quote
  #3  
Old 12-28-2019, 04:29 AM
WibbleWobble WibbleWobble is offline Merging phone numbers with + sign Windows 10 Merging phone numbers with + sign Office 2016
Novice
Merging phone numbers with + sign
 
Join Date: Dec 2019
Posts: 2
WibbleWobble is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging phone numbers with + sign Mail Merge Formatting Phone numbers Marie_Melody Mail Merge 4 07-02-2014 04:22 PM
Merging phone numbers with + sign 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
Merging phone numbers with + sign How to add the plus sign (+) automatically for the numbers which are positive? Jamal NUMAN Excel 2 05-01-2011 03:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft