Automatically select "Yes" when appending tables?

I have several queries that appends to a table... i created a macro to run all of them. Everything works the way it should, only issue I have is that every time I update a table I get:

"You are about to append ___ row(s).

Once you click Yes, you can't use the Undo command to reverse teh changes.
Are you sure you want to append the selected rows?

Yes No"

Is there a way that it chooses "Yes" each & everytime???? Trying to automate this, so all we have to do is click & it runs...

I don't use Macros, but if I recall from some training, you may be able turn this warning off. Look here
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx