Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
AngloAlly
 
Posts: n/a
Default mail merge field for telephone numbers; what switches?

MS OFFICE v. 2002
I would like to format a merge field in a Word mail merge document like the
telephone number formating in Excel, 3 digits for area code-3 digits
exchange-4 digits number, with the dashes. The data bases I'm using are
either from trade show attendees who swipe badges and the fields are
pre-formatted or if I enter the data the column is formatted in Excel for
telephone numbers so I just enter all 10 digits and it formats itself. Once
I insert the field code into the document, what switches can be applied to
have it print out in the merged document like xxx-xxx-xxxx.
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
NO CODE - mail merge to Outlook with attachment with CC BrianH Mailmerge 1 February 10th 10 02:53 PM
can you limit the length of a mail merge field? d warren Mailmerge 1 January 6th 06 04:52 PM
Adding a field to an Off 97 mail merge using Office Pro 2003 TomC Mailmerge 1 January 5th 06 08:00 AM
Mail Merge should allow you to use numbers and text within the sa. ozziebare Mailmerge 1 March 1st 05 07:33 PM
13 numbers added to Word/Excel mail merge field Pat Mailmerge 1 January 19th 05 02:10 AM


All times are GMT +1. The time now is 07:50 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"