Mail merge with SSN

[UniqueTII]

I am using a Mail Merge to print student's information onto form letters, and I can't get their social securty numbers to come through as xxx-xx-xxxx. For some reason, the dashes don't make it to the form letter, so I get xxxxxxxxx. I created an input mask for [SSN] in my table that saved it in the database with the dashes, but that didn't work on the Word document. Any other suggestions?

 

[Roni Sutton]

I KNOW there is an easier way to do this, but off the top of my head, instead of sending my SSN field to the word document, I would send an unbound text box with the value:

left([ssn],3) & "-" & mid([ssn],4,2) & "-" & right([ssn],4)

That gives you the first three numbers, a dash, the middle two numbers starting at position 4, a dash and the last four numbers.

 

[UniqueTII]

It worked...thanks a million...my whole office thanks you.