[RESOLVED] Fun One Here! Exporting Information from Excel to Word

[IGPOD]

Okay... I have predefined content that I need to insert into an excel macro which will auto populate a word document.

Description:
I have about 96 mail-outs that I have to put together, each with a different contractor's name, address, contract number etc.

Most of the content is static, but I need to create a macro that will take the information from my spreadsheet and create a custom letter to the contractors.

Request:
If you could identify where I can place my static content in the code as: "[PLACE STATIC CONTENT HERE]" it would be much appreciated.

One more thing:
To simplify I need this format:

Reference: [Contract Number]

[Contractor Name]
[Street Address]
[City], [State] [Zip]

Dear Mr./Mrs. [Contractor Name]

[Static Content]



EACH OF THE ABOVE IN BRACKETS HAS IT'S OWN CELL REFERENCE.

Thank you in advance, I know someone can do this.