I downloaded your data source file, and placed it in a directory dedicated to your contributions to this project. I'm confirming that all times and dates are in the proper format (as your instructions eluded), with the exception of the r1 through r_8 srl and sru times which are decimal. This is the format of the report you sent

I then re-downloaded your merge document (report) from post #2, and put it in the same directory.

I opened up the report with Word, selected your data file and worksheet "CORE" as its recipient (source). From 'Edit Recipients' I selected "DT" from the type field.

'Preview Results' : (attachment)



Still the same

Select 'Finish & Merge' > 'Edit Individual documents' ...
Get a "Field calculation error occured in record 1", and saved the resulting document.



I've attached the completed document.

As an aside ... when I went to save the document, it insisted on giving it the name of 1.docx, while the document title was letters2. Is this normal? I would have thought it would want to save it as the same name as the document title.

I don't know Paul. Gremlins?

Attached Files

1.docx (386.7 KB, 6 views)

My bad. I've replaced that file with the time formats corrected. Try the new version.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]