View original (French)

A 0 appears in mail merge

Solved
g@zelle Posted messages 107 Status Membre -  
argixu Posted messages 5292 Registration date   Status Contributeur Last intervention   -
Hello,

I just found on the forum the same problem encountered by Fannipon regarding the 0 that appears in the mail merge. I have the same issue: an Excel spreadsheet with a column named Mail, and when the cell is empty, I get a 0. My cell is in standard format.

To modify my field, I press Alt + F9, then using Ctrl + F9 to get the {} I type in the merge field the formula given to Fannipon:

{IF{MERGEFIELD "Mail"}<>0 "{MERGEFIELD "Mail"}" (then I press Enter)
""} and I finish again by pressing Alt + F9.

But my result is: Error! Unknown conditional op code.

I have looked around, but I can't find a similar explanation in the forum's list.

Please let me know where I'm going wrong

Configuration: Windows Vista / Chrome 26.0.1410.64

--
Best regards,
g@zelle

2 réponses

Réponse 1 / 2
argixu Posted messages 5292 Registration date   Status Contributeur Last intervention   4 842
 
Hello

If there is nothing in the cell (no formula or character), Word should not display anything during the merge.

Otherwise, the example you found skips a line. You should have:
{IF {MERGEFIELD mail } <> 0 { MERGEFIELD mail } a paragraph break
"" }

If you don’t need to skip a line
{ IF { MERGEFIELD mail } = 0 "" { MERGEFIELD mail } }

Argitxu
2
g@zelle Posted messages 107 Status Membre
 
Hello Argitxu,

Once again, thank you for your help. I was finally able to modify my merge field and everything is fine.

Have a nice day.
0
argixu Posted messages 5292 Registration date   Status Contributeur Last intervention   4 842
 
Thank you for the response
Remember to mark as resolved
0