Mailing labels and merging
 

I'm doing mailing labels from Outlook. First, I make a contact view
with just the category I want (for instance Christmas), then choosing
the fields.
I end up with this result:
«Full_Name»
«Mailing_Address»

«Mailing_Address» give me the address I have checked as the main
address. So far, so good. The problem is that labels are being made for
people with NO addresses, which wastes a lot of labels. Yeah, I can
delete those after merging in Word, but it would be simpler not to have
them there at all.

So, the question is, what more do I need to do get ""if
«Mailing_Address» is blank, don't print this person".

Mailing labels and merging
 

you can either use fields in word to use the record if a field is empty or
enhance the filter in outlook to only show those with addresses (mailing
address is not empty on filter's advanced tab)

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:



"KathrynBassett" wrote in message
oups.com...
I'm doing mailing labels from Outlook. First, I make a contact view
with just the category I want (for instance Christmas), then choosing
the fields.
I end up with this result:
«Full_Name»
«Mailing_Address»

«Mailing_Address» give me the address I have checked as the main
address. So far, so good. The problem is that labels are being made for
people with NO addresses, which wastes a lot of labels. Yeah, I can
delete those after merging in Word, but it would be simpler not to have
them there at all.

So, the question is, what more do I need to do get ""if
«Mailing_Address» is blank, don't print this person".

Mailing labels and merging
 

oh, that filter thing was just the ticket, EXCEPT, now I have another
problem. My process is to click on Tools Mail Merge, and on resulting
box, I leave everything as default except choose mailing labels as the
document type - so far so good. Click OK and then I get the message
that Outlook has created a mail merge document and that to complete the
setup I have to choose setup in the MailMerge helper document. Now
before, I would do that, and choose the appropriate label, click ok
then I would get another screen that would ask me what fields I wanted.
But now, when I click ok, it gets me back to the helper and there is no
place to choose the fields. What happened?

Mailing labels and merging
 

Got the answer in another thread, and have made a tutorial he
http://www.bassett.net/storage/merge...rgeproblem.htm