Hiding a social security number when merging to a form letter.

[Scott]

I am trying to edit a form letter I created to "mask" all but the last 4
digits of a social security number when I merge info to it from an access
database. Is this possible?

Thanks!

 

[John Nurick]

Hi Scott,

Create a query that uses a calculated field something like this

fSSN: "********" & Right([SSN],4)

Then merge the query to Word rather than the table.