This may be more of a Word related query but I haven't been having much luck on other forums and thought it was worth trying on here.

Basically I need to compile a large number of reports in word format, with an Excel spreadsheet pasted in as part of the report.

Is there any way (third party software, macros etc) I can automatically copy information from particular cells of the excel spreadsheet to other set areas of the word document?

i.e. I want the address line from the excel spreadsheet automatically added to a table on the front page (of the word doc) as well as to the footer of the whole document.

Thanks for your help