merge print word doc and excel worksheet

[MarkRush]

I currently have a macro that creates a statement of work by opening a word template stared on sharepoint and then using bookmarks, inserts various counts, features and statements based on values entered into excel.

That part works great. However the end users then have to print the quote tab from excel using a pdf print driver, print the word doc as a pdf, then merge the 2 pdfs together..

Would love to be able to do it all with one macro..

ideas?

 

[Macropod]

You could have your macro copy the quote range from Excel and paste it into the document, thus having a single printout to produce.