How do I set a line not to print if the merge value is null?

[Yomama]

In Publisher 2002, I am merging data that does not always have a value in all
the columns. I would like to set a line not to print in the case where there
is not a value there.

Specifically, the line looks like this:

quilt owned by: <<owner>>

I want the line to be omitted if the data does not have an entry in the
"owner" column.

Can I do that?

 

[JoAnn Paules [MSFT MVP]]

You could go down thru your entire list and tell it not to print a
particular entry, but then you would not get the quilt style or a date or
whatever other data you have for that quilt. You could reword your
publication but I can't think of anything that would be as simple as you'd
probably like.

So where's the quilt show? And when?

 

[Yomama]

Thanks JoAnn,

The quilt show is in Stanwood, WA, at the high school, put on by Camano
Island Quilters, on April 8-9.

 

[JoAnn Paules [MSFT MVP]]

May I suggest contacting the Evergreen Chapter (Seattle/Puget Sound) of the
EGA? Their members may want to attend the show.
http://www.ega-gpr.org/Chapters/Evergreen.htm.

I'd love to visit but 3000 miles is a *bit* far to drive for a quilt show. I
might be in the area the last couple of days in September but by then the
show will be over. :-(

--
JoAnn Paules
MVP Microsoft [Publisher]

also known as........


--
JoAnn Paules
York White Rose Chapter Newsletter Editor
www.embroidery-marega.org/yorkwhiterose.htm

and...........
JoAnn Paules
Mid-Atlantic Region Newsletter Editor/Web Coordinator
www.embroidery-marega.org

and...........
JoAnn Paules
EGA National Web Coordinator
www.egausa.org

 

[Mary Sauer]

You can avoid blank lines. Your best solution is to open help, all the information is
there.

 

[Brian Kvalheim [MSFT MVP]]

When you go to print, the dialog box has an option to supress blank lines.

HTH

 

[JoAnn Paules [MSFT MVP]]

I was assuming she would have "Quilt owned by:" as part of every card and
just the name of the owner in the data source. And that when she had one
without an owner, the "Quilt owned by:" would not show up.

--
JoAnn Paules
MVP Microsoft [Publisher]

 

[Brian Kvalheim [MSFT MVP]]

Hi JoAnn Paules [MSFT MVP] ([email protected]),
in the newsgroups
you posted:

|| I was assuming she would have "Quilt owned by:" as part of every
|| card and just the name of the owner in the data source. And that
|| when she had one without an owner, the "Quilt owned by:" would not
|| show up.

Good catch.
--
Brian Kvalheim
Microsoft Publisher MVP
http://www.publishermvps.com

This posting is provided "AS IS" with no warranties, and
confers no rights.

 

[JoAnn Paules [MSFT MVP]]

Thank you. (Getting part of my brain back now that I actually have to use
it.)