[[email protected]]

Could someone help me out with the code that would be necessary to
automate the following request: Thanks

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