I have a table in a word document I would like to fill with info in a spreadsheet. The problem is the information is serveral rows long in the spreadsheet and I really don't want to do "Date1" "Date2" etc. This spreadsheet will be revised every month and I need to mail merge the information into this table. For example, the spreadsheets says:
Date Employee Name Points Current Points Code Description
11/18/05 Employee A -10 540 2003a Audit
11/22/05 Employee A -50 490 2005j Audit
11/28/05 Employee A -30 460 2004g Audit
11/01/05 Employee B -100 890 2019 Audit
11/16/05 Employee B -5 885 1601a T-Bred
I can't do a traditional merge as it will print one page per line. I need three lines to go into the table in my Word document. Help!