Merging a Word document and an Excel sheet

danger_mouse_tm

Hi

I have a Word document that has pre trip vehicle inspection form in portrait and an Exel sheet that has a delivery list in landscape.  Is there anyway that I can merge these so that I can print multiple copies on my duplex printer?
Thank you!

me_irl

Yes (scroll down on the link below to "using different orientations")

So, at the bottom of the form I'd insert a page break and then change the orientation of the new page.

https://support.office.com/en-ie/article/Rotate-a-page-to-landscape-or-portrait-orientation-in-Word-9b5ac1af-9998-4a37-962b-a82b689572a9

You can "insert" the excel sheet in to the landscape page by doing this...(either by direct copy / paste or using the "insert object" menu item)

http://www.online-tech-tips.com/ms-office-tips/link-excel-worksheet-to-word-doc/

danger_mouse_tm

Thanks,  I may have to play with it for a while.  My first attempt had the Exel sheet all squished up and yet it still printed 2 blank pages along with the document.  But it's a good start!

JRant

danger_mouse_tm wrote: »

Thanks,  I may have to play with it for a while.  My first attempt had the Exel sheet all squished up and yet it still printed 2 blank pages along with the document.  But it's a good start!

Right click on the top right of the excel sheet in word and select fit contents to window.