Merge error when SkipIf added

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vanessa - 24 Jun 2005 22:29 GMT

I have a SkipIf statement in a mail merge document which should skip the
record if the field 'badaddress' is equal to '*'. This is what I have: {
SKIPIF { MERGEFIELD BADADDRESS } = "*" }.

When I do the mail merge, I get this error: Word could not merge the main
document with the data source because the data records were empty or no data
records matched your query options.

I get this error when a merge one record or a batch of records. When I
remove the SkipIf statement, the merge works perfectly. I also tried {
NEXTIF { MERGEFIELD BADADDRESS } = "*" } but I was still getting letters when
'badaddress = *'.

Any suggestions?

Reply to this Message

Peter Jamieson - 25 Jun 2005 09:14 GMT

One reason why this happens because Word treats * and % as "wild card"
characters when it uses the comparison operators = or <>. However, as far as
I know, it only treats them as wild cards if they are in the second
comparand, i.e. try

{ SKIPIF "*" = { MERGEFIELD BADADDRESS } }

Actually I would probably play safe and use

{ SKIPIF "*" = "{ MERGEFIELD BADADDRESS }" }

but it probably isn't essential.

Peter Jamieson

>I have a SkipIf statement in a mail merge document which should skip the
> record if the field 'badaddress' is equal to '*'. This is what I have: {
[quoted text clipped - 12 lines]
>
> Any suggestions?

Reply to this Message

vanessa - 01 Jul 2005 18:30 GMT

Thanks!!!! That did the trick.

- Vanessa

> One reason why this happens because Word treats * and % as "wild card"
> characters when it uses the comparison operators = or <>. However, as far as
[quoted text clipped - 27 lines]
> >
> > Any suggestions?

Reply to this Message

Rate this thread: