i want to create an automated template

[Michaeldean022]

I have a WORD document that I have create manually each time I run a report.
The data that is unique is stored in an Excel spreadsheet and I want to be
able to :

1. Create and Automated Template in Word
2. Be able to pull the unique values in from Excel

 

[macropod]

Hi Michaeldean022,

You really haven't given enough information for us to work with. Depending on what you're doing, a mailmerge might be appropriate,
as might a simple link between the Excel and Word files.

For example, if there's a table in Excel with a number of columns of data and you want to generate one report per row, a mailmerge
would probably be appropriate.

Conversely, if there is just a small number of cells in a specific location, whose values change periodically, a simple link between
the Excel and Word files would probably be appropriate.