Mailing WORD-EXCEL Social Security Number

Haf09100 Posted messages 16 Status Member -  
Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   -
Hello everyone,

I apologize a thousand times as I know the question has been asked X times!! Unfortunately, I haven't been able to apply the proposed solutions, notably that of M@rina:

{set c1 {= INT ({MERGEFIELD SECU}/100) } }
{set c2 {= MOD ({MERGEFIELD SECU};100) } }
{ c1 \# "# ## ## ## ### ### "} {c2}

When I'm on my Word mail merge and I press ALT + F9 on my social security field, it displays like this:

{ MERGEFIELD "N_SECURITE_SOCIALE" }

What I don't understand is when to enter the 3 lines indicated above and above all, should I leave the line break?

In other words, is it correct to write this? :

{set c1 {= INT ({MERGEFIELD SECU}/100) } }
{set c2 {= MOD ({MERGEFIELD SECU};100) } }
{ c1 \# "# ## ## ## ### ### "} {c2}

Because when I try to enter this formula in the gray area of my field, and I refresh with F9, I no longer have any data...

Thank you so much for your help!!!

Afeda.

1 answer

  1. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    Good evening Afeda.

    That's very curious!
    Did you notice that SECU is the name of the column in Excel that contains the SS number?

    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    1