Yes, I am aware of the code in you first post but, like the code in your last post, it contains no SQL statement! All the macro I provided does is to create a new document containing your:
• Mail Merge Data Source Name;
• Mail Merge Connect String; and
• Mail Merge Query String.
Nothing in that code executes a merge.

As for turning numbers into words and calculating the number of months between two date fields, both of those can be handled by field coding, without recourse to DDE or VBA.

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

I tried copying the sqlstatement provided by a manual mail-merge but it still will not look at the queries with the VBA code.

Macropod. I apologize. I'm very new to Office coding and so really all I'm wanting to do is part of the 'run the document' code I have is to have it automatically open up the mail-merge prompts including the connection type.

We have about 12 different queries (one for each program manager) that links to the same table. I wanted them to manually select their own query (or someone elses, if they're filling in) from a list of all the queries.

Really I just want when I have the code say 'run the mail merge' that all the boxes pop up as if I'd hit the button. If there's a specific SQLString that does that I'll give it a try the one I copied doesn't seem to do the DDE connection so the queries with VBA functions don't appear.

The code that will use what I'm trying to do is here: