Merge to an empty dataset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Collin - 27 Nov 2006 15:59 GMT

I am using Word 2002 and have a macro with a set of linked merges. In some
cases there will be no record that satisfies a query condition. How can I
eliminate the error message that appears and keep the macro running when the
dataset is empty for this query?
Bob Collin

Reply to this Message

Doug Robbins - Word MVP - 27 Nov 2006 18:09 GMT

You know it would be lot easier to help you modify your macro if you pasted
your code into your post. Then we would know what it is that is to be
modified.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am using Word 2002 and have a macro with a set of linked merges. In some
> cases there will be no record that satisfies a query condition. How can I
> eliminate the error message that appears and keep the macro running when
> the
> dataset is empty for this query?
> Bob Collin

Reply to this Message

Bob Collin - 28 Nov 2006 02:29 GMT

Doug,
Thanks for the quick response. I thought there might be an easy answer to my
question. I could transmit the code as you suggested but on thinking about it
I decided it would be neater to test the database before using it to insure
it was not empty for any of the three types of information. This seems easy
to do by writing a sub using autofilter. With Boolian variables generated by
this sub I can bypass the merge code when the database is empty.

Signature

Bob Collin

> You know it would be lot easier to help you modify your macro if you pasted
> your code into your post. Then we would know what it is that is to be
[quoted text clipped - 6 lines]
> > dataset is empty for this query?
> > Bob Collin

Reply to this Message