I used a macro (from here: http://www.gmayor.com/export_field.htm#TextToField and managed to get your error free code over to the fields in the body of the main document. It now appears, with this field code method, that my times are correct in the merges. However, GMayor's macro doesn't appear to function with fields in the header or footer.

I have edited and implemented your field code successfully to exclude reference to the seconds.

So, I am feeling a bit more optimistic, but have a ways to go before I can be completely satisfied with my automated application.

The following issues remain unresolved:
1) I have to be able to use the directory style to ensure more than one record goes on a page. Form letters are not an option as paper conservation is a goal. I believe I have the Excel VBA code adjusted to make the document directory. However, the issue remains with the header and footer information. I am unable to get the fields to populate. I know you had explained this Paul, but I don't understand why I can get the header/footer to populate when I launch the report independent of the VBA (ie through Word direct). I still need to apply your code to the time fields in the footer, but it appears I have to do it manually. My last couple attempts must have failed as I was getting "Error! Too many picture switches defined." errors. (I chalke that error up to bad information being entered)

2) I have some time fields that had originally included an "IF" criteria included.
eg: original statement { IF { MERGEFIELD lights_eligible } = ""YES"" { MERGEFIELD "LoTime" } { MERGEFIELD lights_eligible } }

I do not know how to integrate that into the field code to ensure that "LoTime" displays the proper time format (using the code we have to to ensure this)

3) I need to be able toadapt the SQL statement in the VBA code to allow for variable reports to be run based on the edited recipients using the 'type' and 'subresp' fields. Right now, it displays every record on the one document. To function properly, their are four different reports ... DR, FR, DT and FT that are used based on the 'Type'. I will need to differentiate which report is to be used and then define the SQL statement to reflect the expected data.