Mailing WORD-EXCEL Social Security Number
Haf09100
Posted messages
16
Status
Member
-
Raymond PENTIER Posted messages 58213 Registration date Status Contributor Last intervention -
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.
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.