Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 07-18-2019, 01:59 PM
trikky trikky is offline Phone Number Replace ( ) and - with periods    (I'm ALMOST there) Windows 10 Phone Number Replace ( ) and - with periods    (I'm ALMOST there) Office 2019
Novice
Phone Number Replace ( ) and - with periods    (I'm ALMOST there)
 
Join Date: Jul 2019
Location: Vancouver, Canada (expat Aussie)
Posts: 3
trikky is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
Did you actually attach the data source to the document and complete the merge? It's a bit tortuous but Paul's field codes usually work as intended. This lot is no exception.
Yes. I tested it on the application I'm using and it gave an error. A merge with my original document, that uses {MERGEFIELD LeadBrokerHtcPhone \*MERGEFORMAT} , worked fine (although the phone number formatting is not what I want, which of course is why I'm looking at making the change. When I uploaded the new document with the revised code, I get an error.

Quote:
Press ALT+F9 to toggle the fields and it shows...
Thanks for the Alt+F9. At least I know the correct code is there. I was a little confused before because I couldn't see it.

Quote:
Don't even try to make that into fields without using Import and export field constructions as text. Copy it from the document.
Yes. Did that, using a macro referred to in Macropod's post, and it converted the fields without giving an error, so as far as that is concerned, I THINK it's good to go.

Quote:
Or you could simply add another column to your data sheet with the number as text in the correct format and merge that field instead.
Alas, it's a database somewhere else in the system and I don't think that it's something that I can easily change. I'm looking further into that.

Ultimately, if this code that I'm using SHOULD work, then it's the application that is the issue. I'm thinking it's the {QUOTE} before the rest of the code that's causing the issue, but I wanted to make sure I hadn't made an error somewhere else.

Thanks again for your help.
Reply With Quote
 



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
Phone Number Replace ( ) and - with periods    (I'm ALMOST there) Extracting a phone number from a string that contains text and numbers. hommi16 Excel 2 06-05-2013 09:19 PM
Phone Number Replace ( ) and - with periods    (I'm ALMOST there) Extract phone number from word file donlincolnmsof Word VBA 12 06-19-2012 05:21 PM
Phone Number Replace ( ) and - with periods    (I'm ALMOST there) 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:01 AM.


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