If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merge fields with phone number format
I have a user who has a database that tracks information
on vendors. This database has three fields that are phone numbers using the following format{(555) 555-5555}. This is how the data is stored in the Access table. The field is setup as a text file. We are trying to do a MailMerge into a document and when these three fields are merged the formatting is removed and we only get the straight numbers {5555555555}. I have read through some Access and Word books, but nothing I try has any affect. Any suggestions? Thanks in advance. Denny |
#2
|
|||
|
|||
You have to provide the formatting required in Word with a switch on the
merge field http://www.gmayor.com/formatting_word_fields.htm {Mergefield number\# "(000) 000'-'0000"} should do the trick here -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Denny wrote: I have a user who has a database that tracks information on vendors. This database has three fields that are phone numbers using the following format{(555) 555-5555}. This is how the data is stored in the Access table. The field is setup as a text file. We are trying to do a MailMerge into a document and when these three fields are merged the formatting is removed and we only get the straight numbers {5555555555}. I have read through some Access and Word books, but nothing I try has any affect. Any suggestions? Thanks in advance. Denny |
#3
|
|||
|
|||
Your field (Alt-F9) neeeds to look like:
{MERGEFIELD phone \# "(###) ##'-'####"} see: http://tinyurl.com/4xgd3 "Denny" wrote in message ... I have a user who has a database that tracks information on vendors. This database has three fields that are phone numbers using the following format{(555) 555-5555}. This is how the data is stored in the Access table. The field is setup as a text file. We are trying to do a MailMerge into a document and when these three fields are merged the formatting is removed and we only get the straight numbers {5555555555}. I have read through some Access and Word books, but nothing I try has any affect. Any suggestions? Thanks in advance. Denny |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Phone Activation Number in Canada | Ryan Harberg | General Discussions | 1 | August 27th, 2004 09:54 PM |
Changing the format of a date through a querie for a merge with Wo | v6lady | Running & Setting Up Queries | 2 | July 28th, 2004 11:03 PM |
Phone number formatting | Jean971 | Contacts | 3 | July 1st, 2004 10:35 PM |
How do you format custom fields designed for custom contact forms? | Debalan | Contacts | 4 | May 19th, 2004 11:54 PM |