View original (French)

Mailing postal code Excel

menthe7406 Posted messages 2 Status Membre -  
 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 réponses

Réponse 1 / 4
Argitxu Posted messages 5292 Registration date   Status Contributeur Last intervention   4 842
 
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
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