View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Mailmerge Display as Social Security Number Format

You can try using a format switch in your merge fields, e.g. if you have

{ MERGEFIELD ssn } in your mail merge data source (use Alt-F9 to view the
field codes)

use

{ MERGEFIELD ssn \# "000'-'00'-'0000" }

Otherwise, see http://tips.pjmsn.me.uk/t0003.htm and perhaps try the DDE
option

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Dave" wrote in message
...
I am doing a mailmerge, getting my data from Excell. One column I need is
the
Social Security Numbers. When it goes to the merge document it does not
have
the dashes or spacing , just one string of numbers.
Is there anyway to fix this?
Thanks