Thank you so much for the quick and thorough responses.

Slaycock, Yes it is all in one book. Do I need to break it up?

Macropod, you may be correct in using excel instead of word, I am still unable to automate inserting pages in excel or in word. I have not seen a way to do that in Mail merge, could you direct me?