Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2008

Tip: Looking for answers? Try searching our database.

Mail Merge with multiple address lines - Help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Christi - 08 Feb 2008 17:08 GMT
I am trying to merge with multiple address lines (MSWord 2003 -Form letter
and data source being used).  I have the Address2 field that doesn't always
contain data but after merging it places a blank space for that field.
Example below:

     «Sup_Title» «Sup_First_Name» «Sup_Last_Name» «JrSr»

«Title»
«School_Corporation»
«Address_1»
«Address_2»
«City», «State»  «Zip»

After merge result below:

Mr. Walter Smith
Supervisor
Portview Township Schools
6240 US Hwy 6

Portage, IN  46368-5057
Peter Jamieson - 09 Feb 2008 12:16 GMT
Use Alt-F9 to reveal the field codes in your mail merge main document. Your
address lines will then look more like

{ MERGEFIELD Address_1 }
{ MERGEFIELD Address_2 }
{ MERGEFIELD City } etc.

Change this so it looks like:

{ MERGEFIELD Address_1
}{ IF "{ MERGEFIELD Address_2 }" = ""
"" "
{ MERGEFIELD Address_2 }" }
{ MERGEFIELD City } etc.

Every pair of {} must be the special field braces you can enter using
ctrl-F9, You can't just type the { and } on the keyboard.

NB it can actually look like

{ MERGEFIELD Address_1 }{ IF "{ MERGEFIELD Address_2 }" = "" "" "
{ MERGEFIELD Address_2 }" }
{ MERGEFIELD City } etc.

with an "enter" immediately before the second { MERGEFIELD Address_2 } but
the layout is easily lost in these newsgroup messages.

Use Alt-F9 to make those codes disappear/reappear as necessary.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I am trying to merge with multiple address lines (MSWord 2003 -Form letter
>and data source being used).  I have the Address2 field that doesn't always
[quoted text clipped - 17 lines]
>
> Portage, IN  46368-5057
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.