View Single Post
 
Old 01-03-2016, 10:20 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,384
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote