Publisher Mail Merge - advanced

B

btrigg

2 questions:
How to supress blank lines in a publisher mail merge as
you can in Word (rather than printing a blank line
for "address 2" for instance)
and
How to do an "if/then" in a publisher mail merge (if
field x is blank, substitute field y)

Possible to do these things in Publisher?
 
B

Brian Kvalheim - [MS MVP]

2 questions:
How to supress blank lines in a publisher mail merge as you can in Word
(rather than printing a blank line for "address 2" for instance) and
How to do an "if/then" in a publisher mail merge (if field x is blank,
substitute field y)

Publisher doesn't support If/Then "Statements". There is the Filter Records
option which allows you to determine equal to, less than, etc.
To supress blank lines, go to File > Print Merge > Check the box to "Don't
print lines that only contain empty fields" --
Brian Kvalheim
Microsoft Publisher MVP
http://www.mvps.org/publisher

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top