How to mask first 4 digit number - Mail Merge

Question

Is it possible to mask the first 4 digits in a Mail merge formatting switch so that, instead of the field showing as 01234567, it shows as xxxx4567.

Answer 1

No, I don't believe that's possible using Word's built-in functionality / formatting switches. It would require a macro run on the mail merge result document.

---

Cindy Meister, VSTO/Word MVP, my blog

Answer 2

How abt in access database. would it be possibe do in query

Answer 3

I don't think so, but <ou'd need to ask this in the Access for Developers forum to be sure. The Access help on number formatting doesn't include anything like that.

When you'll ask you'll want to be sure to mention this is to run with mail merge. It is possible to set up Access queries to run code, but that only works with mail merge if you use a DDE connection.

---

Cindy Meister, VSTO/Word MVP, my blog

Answer 4

In the simple case where the numbers are all 8 digits, how about putting the following in your Mail Merge Main Document:

xxxx{ =MOD({ MERGEFIELD mynum }, 10000) \#0000 }

Where mynum is the name of your merge field, and all the { } are the special field cod3 braces that you can insert using ctrl-F9

---

Peter Jamieson

Answer 5

Hi Adcz250,

Thank you for posting in the MSDN Forum.

According to your description, your issue is an non-development related issue. I suggest you repost it on the Word Answers Forum.

Experts there are more familiar with the usage of Word and may give you more suggestions.

Best regards,

---

Quist Zhang [MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.