Hi JennEx,
The code I provided is intended to replace the 'traditional' mailmerge. As you're running the merge from an Excel macro, it's best to use an 'ordinary' document and embed the SQL code for the merge into the macro (i.e "SQLStatement:="SELECT * FROM `CONTROL_1$`""). Amongst other things, that means you don't get the SQL prompt when the document is opened.
If you saved the document as a plain document, so that the mailmerge SQL prompt is no longer generated, I can't see how you'd be getting a connection error message when opening it normally.
As for the persistent issue with your time fields, does it concern all records for that field, or still only some of them? If it's the latter, can you upload a workbook with some that work and others that don't?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|