How do I format a phone number in a mail merge field?

**Nayna** · #11 April 12th 19, 08:01 AM

[quote=Varda;496764]I've read this entire thread several times, tried all the suggestions, but am having the same exact issue the person wrote below. The weird thing is that this happens to SOME of the records, and not all of them.

I've checked my database and the phone numbers are all stored in the same manner. Yet the printed mail merging in Word shows this for some of the phone numbers:
(- ) -1635

Quote:

Originally Posted by me04984

This is an old post but I find it helpful. However, when I put in the code
you suggest, I get ( )- -2462 for example, where it prints only the last
four. What format does the data base have to be in to make it come out right?
Actually, I would prefer having it listed as 207-555-2462 in my listings, if
possible.

Thanks for information.

**henryjones147** · #12 September 17th 20, 11:50 AM

I also want to know about this
dissertation help

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge date format problem with Word 2003	Thang	New Users	1	May 2nd 05 01:55 PM
mail merge with attachments	AS	Mailmerge	5	April 9th 05 09:49 AM
mail merge from excel that changes my format from UK to US format	mark	Mailmerge	0	January 21st 05 03:01 PM
How do I format a phone number in a mail merge?	Kristyn	Mailmerge	2	December 9th 04 08:12 AM
Mail Merge - Date Format	Kilinski	Microsoft Word Help	0	December 7th 04 01:13 PM

Ads