I tried the 'Automating Mail Merge' on a mail merge document as instructed from the VBA Knowledgebase. It did run but not quite automatically. Upon opening the document, an SQL dialogue box concerning the data file comes up and requires input before the merge can begin.

I have tried to create a macro to automate the opening, merging and saving of a series of documents in one fell swoop. The aforementioned dialog box never comes up, but then the macro always hangs up just after the mailmerge command.

Is there anyway to bypass the required input or deal with in in the macro itself?