Converting Word and excel files into one PDF

[PaulKendrick]

Hi,
I have a Word letterhead and an excel spreadsheet containing data. I want to combine the two files into a single page pdf, from these two files. i also need to be able to define where each part of the excel spreadsheet goes on the newly created PDF. ideally id like this to be automated. any ideas?

 

[eugenetyson]

I think the only way you're going to do it is to combine the two either in word or excel so they are on the same sheet then create the pdf. Or use a more powerful program like, InDesign and PDF both the word and excel file, place them in InDesign and PDF out that page.

 

[PaulKendrick]

I have thought baout going down that route to be honest and may end up giving it ago. My boss insisted that Acrobat could do this and asked me to find out but i cant see any way of doing it.

Thanks

P.s. if anyone else has an idea, im still listening!

 

[jmgalvin]

Acrobat can combine separate pdfs, by inserting pages, but is not intended to modify any page - like adding a letterhead at the top of each page. You're probably better off just making a Word doc with teh letterhead and importing the excel into that.

Importing the excel into Word should also help you figure out what parts go where by fiddling with what rows & cells you want to bring into each page of the Word doc. use the print preview function in Word to see what the output will be. If you choose Adobe Virtual printer as your printer in the Word print window, the pdf will match the print preview.



Using OSX 10.3.9 on a G4