zip code issues when working with mail merge and excel

E

ernie

i am having trouble getting the decimal point off my zip code when working
with mail merge and excel...what i am doing wrong?? any suggestions would be
appreciated. thanks!! I am working with the most recent edition of word.
 
P

Peter Jamieson

Try using Alt-F9 to view your field code and change e.g.

{ MERGEFIELD Zip }

to

{ MERGEFIELD Zip \#"00000" }

Peter Jamieson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Merging from an Excel file with graphics 1
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Page numbering with Merged Document and IF statements 1
Mail Merge - displaying a conditional number of decimals 5
Mail Merge skipping records/sending one at a time 0
Duplicate Mail Merge Record Every Time 5
Mail Merge Switch - Dollars to Words 0

Top