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.

Getting Rid of Text on Blank Labels

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MBP - 12 Jul 2004 18:09 GMT
I am merging sheets of labels in Word with an Exel file,
but the blank labels that have no records are retaining the
words "Field Museum of Natural History" which is in the
main label merge document.  I have tried placing this line
in the "Quote" field, "Autotext" field and "text box" to no
avail.  I cannot get rid of this line on the blank labels
without manually deleting them.  Punctuation in the main
document disappears after the merge on the blank labels, so
how can I get this line to disappear on the labels that
have no records to merge with?

Thanks.
Doug Robbins - 13 Jul 2004 02:00 GMT
Include that text in an If...then...else field

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> I am merging sheets of labels in Word with an Exel file,
> but the blank labels that have no records are retaining the
[quoted text clipped - 8 lines]
>
> Thanks.
MBP - 13 Jul 2004 17:59 GMT
Yes, thank you!  I had tried this already, but since I've
changed the order of the conditions to be met, it now seems
to work flawlessly.

>-----Original Message-----
>Include that text in an If...then...else field
[quoted text clipped - 13 lines]
>
>.
 
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.