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

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

Guest

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!
 
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.
 
Back
Top