Phone Number Replace ( ) and

trikky · #1 07-17-2019, 01:14 PM

I have a mail merge document where the source phone number is (123) 456-7890. I want the phone number on the completed document to appear as 123.456.7890 .

I have used some info I found elsewhere from Macropod with a potential fix, but it doesn't seem to work in the application I'm using for the merge, so I'm thinking I'm missing something. I've attached some files to help understand what i'm getting here.

On the document I'm designing, when I add the field, there is not a visible reference to the fieldname (mailmerge_entered.jpg). I'm thinking this may be the cause of the error in the application I'm using.

When I expand the mailmerge field (Shift+F9), I can see the QUOTE tag and nothing much else). (mailmerge_expanded.jpg), so it's there.

When I Update the field, the number formatting seems to be formatted correctly. (mailmerge_update.jpg)

I would appreciate someone looking at the attached file (the macro is one from here that converts text to the mailmerge format) and let me know if I'm missing anything.

Thanks in advance for any assistance you can offer.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Add custom phone number field to Outlook 2013 Contact?	King Mustard	Outlook	0	06-10-2015 08:12 AM
Extracting a phone number from a string that contains text and numbers.	hommi16	Excel	2	06-05-2013 09:19 PM
Extract phone number from word file	donlincolnmsof	Word VBA	12	06-19-2012 05:21 PM
Phone number formatting	Mark Micallef	Outlook	1	08-04-2010 02:38 PM
in WORD, how do i type a 9-digit phone number "xxxxxxxxx" and have it automatically..	jay8962	Word	0	04-08-2010 11:08 AM