Hi Deb,
Once you insert the mergefields, the document is permanently set up for the packing slip production.
As for inserting the table into the document, the issue there is that your Excel pages are somewhat oversized.
The attachment gives you an idea of how the mailmerge will do. I had to make a few small changes to the workbook, by:
• naming the mailmerge data range (Orders);
• adding some more column names on row 2 (which is where the mailmerge data range starts); and
• adding a column for the school names.
When you open the document, Word will ask whether it should run a query. Answer Yes. Word may then prompt you for the data source. If so, simply point it to the workbook. Then go to the Mailings tab and click on 'Preview Results'. You can then view each record. If you wanted to print just one record, you could do it from there. If you want to print the lot, click 'Finish and merge', from where you can create a single document containing all the records, or send them direct to the printer.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|