I am trying to create a fax coversheet and cannot use the MS Word template. The data is coming from another program called ATO, but I have replicated that data in an excel spreadsheet.

The fax coversheet must have the recipients listed before the sender information. The recipients name, phone, fax and company information is set up in a table and each recipients information is in a separate row.

My problem is:
The SENDER information does not fill in. If I have 6 recipient rows and 6 recipients then the sender information does fill in. If I remove 1 recipient the sender information does not fill in. WHY?

I cannot use fill-in or Ask codes, nor can I use hidden text with ref codes because ATO does not allow them. HELP?????



I have attached sample documents.
Fax Form.docx

Fax Merge Data.xlsx

Image of my problem.jpg