You should indeed create the mailmerge main document with all the boilerplate text and field coding you require. Trying to code all this into a macro will end up generating something that's a nightmare to maintain. User's really shouldn't have any difficulty opening the mailmerge main document, answering 'Yes' to the SQL prompt, then finishing the merge. If you're wedded to the mailmerge being run from Excel, the mailmerge main document that you do the set-up on could then be automated.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]