Mailmerge Display as Social Security Number Format

[Dave]

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

 

[Peter Jamieson]

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