I have a summary sheet with a list box that pulls data from several sheets. I
have about 30-40 names in this list box. Instead of selecting the name 30-40
times from the list box, is there a way to click once and print the data for
all this 40 names.
Thanks
Shaj

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 ToolsMail 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 ToolsMail
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


"shaj" wrote in message
...
I have a summary sheet with a list box that pulls data from several
sheets. I
have about 30-40 names in this list box. Instead of selecting the name
30-40
times from the list box, is there a way to click once and print the data
for
all this 40 names.
Thanks
Shaj