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

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!
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding a social security number when merging data to a form letter 3
Hiding part of a Social Security Number 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Can't find "Social Security Number" data in Input Mask Wizard Wind 1
Not allowing duplicate employee last name, first name 4
How do I calculate age from social security number? 5
How to display last for digits of SSN? 4
How do I do display xxx-xx-1234 in an access report 10

Top