View original (French)

Word 2007 mail merge do not display zero

laetice13 Posted messages 69 Registration date   Status Member Last intervention   -  
Polo141 Posted messages 215 Status Member -
Hello,

I just created an Excel table.
When I start the mail merge, Word shows a zero where the fields are not filled in. How can I prevent the blank line from showing up?

Thank you very much

Configuration: Windows XP / Firefox 3.6.10

4 answers

  1.
    Polo141 Posted messages 215 Status Member 113
     
    I found the solution

    - In your first transposition cell, enter the formula =IF(TRANSPOSE(table)=0,"",TRANSPOSE(table))

    - Then redo the classic method required for applying the TRANSPOSE formula (that is, select all the cells where the transpose will take place as the destination, then press F2 followed by the key combination CTRL + SHIFT + ENTER)

    Explanations

    You cannot change each cell of your transposed matrix independently. However, you can use the same formula for your entire transposed matrix. Otherwise, you will receive the message "Cannot modify a part of the array"
    3
  2. m@rina Posted messages 27617 Registration date   Status Moderator Last intervention   11 563
     
    Hello,

    No, it's a field to put in your Word mail merge document, instead of your field.

    The { } must be obtained by pressing Ctrl+F9.
    --
    - "On the office forum, questions are asked about office applications..."
    - "Oh really ???"
    1
  3. m@rina Posted messages 27617 Registration date   Status Moderator Last intervention   11 563
     
    Hello

    Are you sure the Excel cells are empty???
    Because in principle, if a cell is empty, Word displays nothing.
    If the cells contain formulas that result in nothing, it's true that we can get 0s in Word. In this case, you would need to use a condition like {IF {MyField}=0 "" "{myField}}

    m@rina

    --
    - "On the office forum, questions are asked regarding office software..."
    - "Oh really???"
    0
  4. laetice13 Posted messages 69 Registration date   Status Member Last intervention   1
     
    Hello m@rina,
    indeed, you are right, the Excel cells are not empty
    my sheets are linked so for the mail merge I copied everything onto another sheet without links, just the values,
    but as a result, Excel shows a 0 in the empty cells when you click on them
    otherwise they are empty on the screen
    I converted the cells to text format but nothing changes
    the formula you gave me, do I need to copy it into Excel? I've never done this in Word, can you help me?

    thanks again!!!
    0