View original (French)

A 0 appears in mail merge

Solved
g@zelle Posted messages 107 Status Member -  
 Anonymous user -
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 answers

  1. Anonymous user
     
    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
    1. g@zelle Posted messages 107 Status Member
       
      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
    2. Anonymous user
       
      Thank you for the response
      Remember to mark as resolved
      0