Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Switch for mail merging telephone-number field
How do I format a merged text field to display as a telephone number in the
merged document. Can't find the rigth switch to add characters and spacing. F.e: Access source: 5128925552 -- needs to result in Word merge document (512) 892-5552 Source: Access table, field type: Text |
#2
|
|||
|
|||
I would always use a query in Access to manipulate/format data, but if you
want to do it in Word, See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP "Rene" wrote in message ... How do I format a merged text field to display as a telephone number in the merged document. Can't find the rigth switch to add characters and spacing. F.e: Access source: 5128925552 -- needs to result in Word merge document (512) 892-5552 Source: Access table, field type: Text |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Switch for mail merging telephone-number field
In a similar case, I used a query in Access to manipulate data into being a
percentage with no decimals. In the Word document, those fields are neither in percent form, nor integers. Can you help via Access, or should I go to the site you mentioned, and piddle in Word switches (which I've never done)? Thanks in advance, Shannon "Doug Robbins - Word MVP" wrote: I would always use a query in Access to manipulate/format data, but if you want to do it in Word, See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP "Rene" wrote in message ... How do I format a merged text field to display as a telephone number in the merged document. Can't find the rigth switch to add characters and spacing. F.e: Access source: 5128925552 -- needs to result in Word merge document (512) 892-5552 Source: Access table, field type: Text |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Switch for mail merging telephone-number field
For the phone numbers, all you need to do is to add a picture switch to the
mergefield in you mailmerge template. To do this: .. select the mergefield .. press Shift-F9 to expose the field code. It should look something like '{MERGEFIELD MyData}', where 'MyData' is your data field's name. .. delete everything between 'MyData' and the closing field brace .. add ' \# "(000) 0000 0000"' after 'MyData', so that you end up with '{MERGEFIELD MyData \# "(000) 0000 0000"}' .. press F9 to update the field .. run your mailmerge. Cheers -- macropod [MVP - Microsoft Word] "Shannon" wrote in message ... In a similar case, I used a query in Access to manipulate data into being a percentage with no decimals. In the Word document, those fields are neither in percent form, nor integers. Can you help via Access, or should I go to the site you mentioned, and piddle in Word switches (which I've never done)? Thanks in advance, Shannon "Doug Robbins - Word MVP" wrote: I would always use a query in Access to manipulate/format data, but if you want to do it in Word, See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP "Rene" wrote in message ... How do I format a merged text field to display as a telephone number in the merged document. Can't find the rigth switch to add characters and spacing. F.e: Access source: 5128925552 -- needs to result in Word merge document (512) 892-5552 Source: Access table, field type: Text |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
form field,can I add a telephone number under the number field w/d | Microsoft Word Help | |||
Why can't I see 'home phone' field when mail merging from Outlook. | Mailmerge | |||
Date issue merging from Excel field in Date format to Word | Mailmerge | |||
Text Form Field Ref in Footer Won't Update on Screen | Microsoft Word Help | |||
Number fields not merging correctly | Mailmerge |