Combining Excel and Word documents

[city_girl4you]

Hi All,

I have created a sales contract for my sales reps in excel which will automatically calculate totals. The full contract however includes 3 pages of excel documents and 1 page of terms and conditions which is in Word.

Currently they would have to print four documents to create the full contract. Is there a way to combine both the excel and word documents so that I can save it all as a template and they only have to print one document instead of the 4 separate ones I have now?

Ultimately my goal is for them to hit print and the whole sales package would print.

Thanks in advance for any help I get.

 

[Domski]

Hi,

There was a package called Microsoft Binder that you could use to collect different types of document together for printing etc.

They stopped disctributing it with Office 2003 I think but if you've got an earlier version you may have it installed.

Dom

 

[larrydunn]

It's not hard to copy the three additional pages into separate sheets in your Sales Contract workbook. I'm assuming each of the three pages is a separate sheet - not that it matters. It still should print fine.

Making a macro to print all sheets in the workbook is fairly easy to do. Many people at MrExcel can help you with that.

If I were doing it, I would go get the text from Word and paste it into a blank Excel sheet. (Use Edit - Paste Special - Text to do this.) Then I would re-format the text, and essentially rewrite it to get it to print correctly in Excel.

Then that print macro I mentioned earlier would in fact print all sheets of your sales contract.

Incidentally, if you decide to try putting the Word page in Excel, I've found that it helps to include a second column at the right in the print range, and then reduce it to a width of 1. That way, it doesn't distort the printing, but forces Excel to include all the text in the left-hand column.