Article ID: 211421 - View products that this article applies to.
This article was previously published under Q211421
In Microsoft Word, when you perform a mail merge with an external data source that contains phone numbers, the phone numbers are incorrectly formatted in the mail merge results. The separator characters may be missing or incorrect, or you may receive the following error message:
For example, if the expected phone number is (999) 555-1212, the number may appear as one of the following:
Error! Picture String contains unmatched quotes.
(999) 555 1212
This problem occurs when you use data from Microsoft Access or another database source that can store phone numbers as ordinary numbers but can present them with the correct formatting in the native program.
During a mail merge, the data appears in its native, stored format from the external data source. This occurs when the merge field for the phone number is missing the numeric picture field switch or has incorrect syntax.
To work around this problem, use the numeric picture switch "\#" in the merge field for the phone number. Follow these rules when using the numeric picture switch "\#":
Contact us for more help
Connect with Answer Desk for expert help.