output of lists of 10 rows from excel worksheet to word, by date range

Hello all

i have an excel worksheet with data around 800 entries

i want to print data in word ( prepare data to be printed)
based on a range ( one of the colums has a date ) so i want for instance select june month ( from start june to end of june) and then save data by 10 rows in word doc ( 10 rows per page in word ) ( a sort of paginated thing printed in each page of word for that range

are there any means to do that ?


thank You

Yes. The way to do this is to drive it from Word rather than Excel.

So
- Open Word
- Go onto the "Mailings" ribbon
- click on "Start Mail Merge" followed by:
- "Step by step Mail Merge Wizard"
which should take you through most things.

What you are actually doing is
- linking Word to the correct sheet in your Excel file
- selecting which fields (ie Excel columns) you want where on the page in word
- creating a template that can be used many times
- running the Mail Merge and selecting which records you want ( a row in Excel is a record)
(There are lots options to help with selection)

Some Tips
Form what you have said, choose document type "Directory", which will give your list of 10 rows etc.
Sort your data into the correct sequence in Excel first - and then at least everything comes out in the correct order in Word.
Try a few Mail Merges and see how it works

There are lots of tricks to getting exactly what you want, but if you master the basic mechanics of Mail Merge first, we can then help you further with the specifics later.