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]
|