Mail Merge from Excel to Word-how to set up Zip Code on separate l

F

falcios

When I do a mail merge from Excel to Word the zip code is on the same line as
the city. How can I set it so the zip code is on a separate/last line?
Thanks.
 
G

Graham Mayor

Instead of using the address block field, use the individual fields that
make up the address, formatted as you require them.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

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

Auto Populate One Pages from spreadsheet 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Merging from an Excel file with graphics 1
Merge Excel file into Word Document 3
How to display the merge function "url" of a picture? 0
Auto Merge text from multiple sources 0
Mail Merge Directory Conditional Page Break 0

Top