Wondering if the following process could be done from within Excel or
if we actually need to perform the process and complete it in Word.

*******************************

Underwriter business developer will generate Excel file In the Address
TAB a button is being added that will contain VBA code that will
execute the following:

Count number of records (Range A7.......En)
Open Word
Create a 30 cell table much like the one attached
Insert Agency field Name
Insert Agency Address
Insert Agency City
Insert Agency State
Insert Agency Zip
Font Size 8
Format:Centered
Propagate fields to all Cells