Formating a Merge Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I setup a merge field so that the result appears in a specific
format? I need to do a mail merge using an Excel spreadsheet as the source,
however the telephone numbers are not formated as such (eg 4079947953). For
the merge, I need them to appear formated as phone numbers.
 
My phone numbers as coming in from a access database and are in text fields.
Do I need to change them to number fields?
 
That rather depends on the result you get when you enter the field without a
switch. If it is a number then no.

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

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

Mail merge between Word and Excel 1
Merge Field w/Date 1
Merge format switch issue? 4
Mail Merge and Access format of telephone number 2
Currency format lost when merging into Word 1
Format Merge Field 1
Mail Merge Question with Excel 4
Decimal places in mail merge 1

Back
Top