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 / July 2004

Tip: Looking for answers? Try searching our database.

Space for Empty Fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Brett Weiss - 29 Jul 2004 17:34 GMT
I am merging contact information into a label. There are fields for
FirstName1, LastName1, FirstName2, and LastName2. While there will always be
an entry in FirstName1 and LastName1, often there won't be in FirstName2 and
LastName 2.

I don't see how to use the If...Then function (or some other function) to
set up a merge so that if these fields are empty there won't be an empty
line for the label.

Could someone point me in the right direction?

Signature

Brett

Greg - 29 Jul 2004 18:33 GMT
Brett,

This is done with a conditional field with a line break
starting on the same line as the FirstName1 and LastName1  
field.  IF the condition is met, a line break is inserted
and the FirstName2 and LastName2 is applied on the next
line.  IF not, nothing happens after LastName1.

{FirstName1}{LastName1}{IF {FirstName2} <> """ILBH
{FirstName2}{LastName2}"""}

ILBH was used for "Insert Line Break Here" meaning
Shift+Enter.

>-----Original Message-----
>I am merging contact information into a label. There are fields for
[quoted text clipped - 7 lines]
>
>Could someone point me in the right direction?

Rate this thread:






 
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.