View original (French)

Mailing postal code Excel

menthe7406 Posted messages 2 Status Member -  
 VBLN -
Hello,
I would like to print labels using the mail merge feature.
I created an Excel file that contains all the addresses, but there is an issue with the postal code.
When I preview the data at the moment I choose my Excel data source, the postal codes do not display the leading zero for departments 01, 02, 03, etc.
I have modified the cell format trying various types: custom, text, special postal code, but nothing works!
Thank you for your help!

4 answers

  1.
    Argitxu Posted messages 5292 Registration date   Status Contributor Last intervention   4 844
     
    Hello

    You need to force the format in Word
    Press alt F9 to display the merge field codes
    In the postal code field, add \# 00000
    to end up with { MERGEFIELD Codepostal \# 00000 }
    Press alt F9 again to hide the code

    --
    Argitxu
    13
    1. VBLN
       

      Hello,

      is it possible for you to explain to me differently the methodology to display the first 0 of a postal code during a mail merge in Word, as I am struggling to do it.

      Thank you in advance.

      0