Another If..Then...Else

[Peggy Knott]

Merging Labels in Office 2000. The label contain First2, Last2. If
there is no First2 then the next record should be accessed, otherwise it
should print the label. Now we are getting blank labels if there is no
First2. We have filtered the Excel data list and done a separate merge.
How do I word the If..Then..Else so it is not necessary to perform
this extra step? Thanks for any help you can provide

 

[Cindy M -WordMVP-]

Hi Peggy,

Merging Labels in Office 2000. The label contain First2, Last2. If
there is no First2 then the next record should be accessed, otherwise it
should print the label. Now we are getting blank labels if there is no
First2. We have filtered the Excel data list and done a separate merge.

May we assume you've filtered the Excel list to not show records where
First2 is empty? In this case, you should now

- go to Word's Query Options (You'll see this button in the mail merge
Helper or the dialog box you get when you click the Mail Merge... button in
the toolbar)
- select the First2 field from the list and set it to "Not blank"

Now Word should filter out those blank records. (Note that you could do
this in Word without first filtering the Excel recordset)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Peggy Knott]

Thank you. I was making it way too difficult. My user did not want to
filter Excel first and, of course, the query options in the Merge dialog
box does what is needed.