Creating Report template in Word & Excel or Access

[dlc444]

Hello all.

I am trying to automate at least a portion of my work.

I write commercial appraisals that are generally between 100 to 150 pages
where there is a lot of repeated information, such as the name of a
property, address, client, etc.

I have been looking for a method whereby I could create a spreadsheet (or
database) that would automatically import certain fields throughout a
document while maintaining the formatting of the main document. If the
information in the spreadsheet changes, it is bumped over to the word
document (and vice versa if possible).

Entire sections could be written in a spreadsheet which could be shared
between coworkers and updated on the fly as new information is acquired.

Does anyone have any suggestions on how to do this? I have done some
programming, but nothing like this.

 

[Doug Robbins - Word MVP]

A couple of years ago, on a commercial basis, I created such an application
for a guy name Matt Griffith email address:
mgriffith[atsymbol]tropicalappraisal[dot]com

You might contact him and see if he is prepared to share it with you on some
basis.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com