I developed an userform that adds records to an Excel table, saves it, then calls Word to print a mail merge of last, just added record.
The userform has worked perfectly, growing the table regularly to over 230 records, then suddenly has started to halt with a 5631 Error (data not present).
I tried to rebuild the table, record by record; I re-created from scratch the Word document and tried to relink it to the table, but it 'sees' only the first 59 records, so any new is 'not present'.
I run out of ideas, what could have happened?