Hi
Create a summary sheet, where all data needed for a report, are together on
a single row. Place the summary sheet as first one in workbook. Save the
workbook.
Open Word. Select from menu Tools>Mail Merge
Create a main document as form letter.
Open data source - set file type to *.xls and open your excel workbook.
Select Entire Spreadsheed when asked.
Edit the main document: type in the common text for all reports, insert
merge fields to get data from your summary table (field names are column
headers - you MUST have a single header row in your table. And no gaps in
table.)
When ready, then save the merge document. NB! Once it is created, you can
use it repeatedly!
To print report(s), you have to open the merge document (the source table
used at last saving is opened too), unless it is open. Select Tools>Mail
Merge, and click on Merge button. Determine the output media (word document,
printer, fax, e-mail), and filter(s) (filters determine, which rows from
source table are processed), and press on Merge button.
Arvi Laanemets
