mailmerge. end merge or skip record when quantity is 0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon - 11 Jan 2007 11:13 GMT

How do your end the merge when the remaining records in the import file
(excel) are 0.

This should work with a database query, however the error database engine
failure is returned, and cannot open source file.

Can merge ok, as long a a query isnt raised. I have checked on the forums
(and tried DDE, and using another computer) but still the same problem.

Reply to this Message

Graham Mayor - 11 Jan 2007 15:12 GMT

Use a SkipIf field to test whether a field is empty or equal to 0
eg
{ SKIPIF { MERGEFIELD Fieldname } = "" }

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> How do your end the merge when the remaining records in the import
> file (excel) are 0.
[quoted text clipped - 5 lines]
> forums (and tried DDE, and using another computer) but still the same
> problem.

Reply to this Message