How about creating the Word Document as a MailMerge with the MergeSource being a table or view in the database.
Your code would then only need to fill the table. Opening the Document and hitting Merge to file to create the big file, or Merge to Printer to print them all.
JimFive
Your CommandType is a StoredProcedure, so your recordset is not updatable. You need to have a Table or Updatable view to update data this way.
JimFive.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.