MERGING

  • Thread starter Thread starter Ransom
  • Start date Start date
R

Ransom

Hello,
I am trying to format a merge field in Word 2003.

I have the telephone field placed but once the merge occurs from Access the
number shows like this 3019251788. How can I get it to display like this
(301) 925-1788 or 301-925-1788?? HELP

Thanks
Ransom
 
You need a switch on the merge field. Toggle the display with ALT+F9 and
change the {Mergefield PhoneNoField} to
{Mergefield PhoneNoField \# "(000) 000'-'0000"}
or
{Mergefield PhoneNoField \# "000'-'000'-'0000"}
depending on which layout you prefer
Then F9 to update and ALT+F9 to toggle again

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Thank you!! worked like a charm

Graham Mayor said:
You need a switch on the merge field. Toggle the display with ALT+F9 and
change the {Mergefield PhoneNoField} to
{Mergefield PhoneNoField \# "(000) 000'-'0000"}
or
{Mergefield PhoneNoField \# "000'-'000'-'0000"}
depending on which layout you prefer
Then F9 to update and ALT+F9 to toggle again

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I use ^#^#^#^#(space)^$ FIND and REPLACE with ^#^#^#^t^$ ? 1
Mail merge between Word and Excel 1
Get selected word documents from user's choice and merge those documents as a single doc file 0
Merging Excel file with Word document 6
MS Word, forms, field size fixed? Regardless of data length? 1
Mail Merge and Access format of telephone number 2
Trying to make index cards 1
How do I truncate decimal places on a merged field? 1

Back
Top