I'm writing a simple macro that opens a Word 2003 document which is a label merge doc.

1.When the document opens, Word prompts to say that Data from my Database will be placed in the document and do I want to continue. At this point I want to write into the macro to automatically respond "Yes". This is the option that is selected by default.

2. Word then prompts to select the text separator from Tab, Comma or Other. Comma is the default selection, and it is the one I want. At this point I want to write into the macro to automatically respond "OK", which is the default selection.

Everything else - the opening as read only, toggling the view, and saving as a new file I have been able to successfully manage.