I must admit Graham, you are far more advanced than I in understanding all this complex issue.

Your instructions are most detailed for your Add-In, but, this is just me now, I am not after how to use an Add-In.

I want to be able, myself, to use Word Field Codes to perform an email merge using Word as the source document, Excel as the data source (Table as you suggest), and Outlook as the conveyor of the email messages. I am adept at sending one to one, i.e., one record = one row in Excel. However, in my situation now, each facility (record) has multiple rows of information, i.e., chemicals. If the facility only had one chemical, "piece of cake" - can send those out all day long. Although I do not want to do this, it may be easier to create individual Word documents for each facility and send as an attachment to the email?

Your expertise is admired.
Best week's wishes,
Mort in Dallas