Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
falcios falcios is offline
external usenet poster
 
Posts: 22
Default Mail Merge from Excel to Word-how to set up Zip Code on separate l

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.

  #2   Report Post  
Posted to microsoft.public.word.tables
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mail Merge from Excel to Word-how to set up Zip Code on separate l

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



falcios wrote:
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.



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge losing Zip Code format from Excel to Outlook? ArtGle Mailmerge 1 July 24th 08 06:24 AM
When I mail mrge from Excel into Word, it drops 1st 0 in zip code AllenVV Mailmerge 2 December 4th 05 06:45 AM
zip code issues when working with mail merge and excel ernie Mailmerge 1 April 21st 05 08:34 AM
Formatting zip code in mail merge from Excel to Word Zip code help Microsoft Word Help 1 February 10th 05 01:50 AM
How can I perform a Word mail merge to separate files jjeffh Mailmerge 1 January 17th 05 04:45 PM


All times are GMT +1. The time now is 03:10 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"