Inserting multipage PDFs via MailMerge?

Hello, I am a new member and this is my first post here.

I'm currently assembling submittal sheets for a drawing package. This involves writing up a cover sheet, converting it to pdf, then attaching the manufacturers specsheets (also in PDF) to it, and repeat ad nauseum for about 200 devices.

I am already using a mailmerge to do up the cover sheets. Instead of names and addresses, we'd use manufacturer name, device, name, manufacturer website, etc and then export the mailmerged results as PDF. But, i'm still tasked with having to open up the cover sheet pdfs and manually insert the manufacturers specsheets in with the cover sheets.

Word has no facility for importing multi-page PDFs or other objects, whether by mailmerge or otherwise; the most you can do is to insert a single page (which will only ever be the first page of a PDF) or insert it as a clickable icon (which isn't much use for printed material).

Darn. Thanks for the reply anyway. At least I know I can stop chasing that particular dead end.

If I was to somehow convert a multipage pdf to an image (long vertical length), would word be smart enough to chop it across multiple pages? or would the inserted image simply be squished into one page?

No, an inserted object cannot span page boundaries; whatever's too large to fit at 100% is liable to be scaled down till it does. Consequently, you'd have to break the object up into one-page blocks and insert each one individually. IIRC, inserted PDFs often print poorly too.

For instance, you could automate Acrobat (if you had it) using VBA. You could use that macro to save the Word coversheet as a PDF and then add the specsheet PDF behind that PDF.

An alternative is to export PDF pages as images (one page = one image) so those images can then be imported into Word as one-page graphics (using the mail-merge functionality).

Do you own Adobe Acrobat? Do you know how to write VBA macros?

What we are doing at this moment is using the mailmerge in Word to create the coversheets only. The merged coversheets are then exported as one .pdf. Then in another program we insert the manufacturer pdf specsheets with their matching cover sheet, and save it again. It is then appended to the final drawing package (which is again... in PDF) and submitted to the contractor digitally.

I haven't coded in VBA at all. To a small degree, I can follow how a program is developed and what it is doing. My experience in coding is with Basic for microcontrollers (mechanical background). A lot of the commands are the same, but instead of pins and voltages, it's files and objects (I think).

I've thought of exporting our current specsheets as images. I've had success in getting the tutorial to work from the other thread (inserting images into letter via mail merge). However since our submittal sheets vary in size (1 sheet to as many as 11) I've noticed that if an image is blank, it will insert pages with a small error message on them. File not specified or something to that effect. Which could make more work again.

Originally Posted by macropod

Be aware that this requires Adobe Acrobat Pro, not just the Reader. The good news is that Adobe has made version 8 of Adobe Acrobat Pro available as a free download.

Since your specsheets are PDF and the final output is PDF then I would forget about including the specsheets in the Word document. It is easier to stitch the files together after you turn the Word file into PDF.

The full version of Acrobat (including Acrobat 8) allows you to either merge PDFs and doesn't require automation to do this quickly.

Andrew, that is more or less what we're doing now. But, we're doing so by hand.

I'd really like to find a way to automate this in order to avoid stitching together by hand. A very small project with maybe 10-20 devices isn't too bad. But, on some projects that involve over 200 different devices, stitching that many coversheets and submittals together by hand is time consuming and tedious (as well as creates opportunities for dumb errors)!

Is there a similar tool to mail merge in acrobat that would get me closer to what I need?

Whilst you can automate this, the trick will be naming each of the files to allow the macro to work out where each file sits in the order. If you have to customise this file order every time you are doing the task then you might as well just use acrobat's merge functionality anyway.

Perhaps an easier way is to keep all the PDFs separate and include a mailmerge-supplied hyperlink in each Coversheet which opens the relevant product sheet. The user will still navigate the resulting file(s) logically and your preparation time is minimised.

The method you have linked to is, more or less, how i am doing assembling the files now. I open the coversheets (that are in one continuous pdf file) in acrobat then drag and drop the spec sheets into place. The finished pdf assembly is saved and dropped into the drawing package pdf.

The spec sheets are saved locally on our network so we don't have to go surfing manufacturers websites every time we need them. Because we save them locally and do not move the folders or files around, I had myself myself convinced that there is a way to get these Word or something to do the insertions automatically by using an excel sheet as a type of database. Mail merge was looking promising since it was able to pull up images that were linked, but not anything else.

Does the order change? yes. But a lot of jobs use the same devices. specialized devices aren't really a big deal either. we'll typically just add the device and spec sheet as we go.
The cover sheets change for each job also since we display the title of the project on each sheet.

I don't think the hyperlinks would work out since they wouldn't be useful to the field staff. We don't usually print the drawings out for ourselves here in the office, but the contractors sometimes do for the technicians.

Sorry if it sounds like something new is popping each time I reply. I appreciate the amount of effort you've given already

I think the time-consuming part of this is your dragging pdfs into a specific location in the single document coversheet file. I think it would be faster to export the Coversheet file as separate PDFs and then assemble the complete set in your preferred order where every second file is a coversheet.

You can create a script to merge PDFs in a defined order but we would need to know a lot of information such as what versions of Word and Acrobat you are using and where the information on file order would be coming from and how the merge files are structured etc. Because there are so many variables in getting this to work through a coding solution, it is a less preferred option than the more direct route.

Any solution involving PDFs inserted as graphics into Word is going to be dodgy because the resulting output is unlikely to be word searchable and likely to suffer either image quality and/or file size issues.

Perhaps you could ask the same question on the PDF forums to see if someone has already created a script to merge files in a specific order based on a text input file.

Have you looked at IrfanView. It can merge PDFs and in command line mode can use file lists. I use V4.36 and if you look at the Help FAQ & Command Line Options I think you could easily work a solution in conjunction with your Excel speadsheets to create the file lists. You may have to include Ghostscript.

IMHO If you are using Word's .pdf maker you are on a hiding to nothing as MS Word really does not create efficient .pdf's (it produces really huge files).

You really need to use Adobe Acrobat Pro - or similar such as Foxit or PDF Converter Pro (as suggested elsewhere in this thread) then you can add, subtract, combine, insert links and manipulate .pdf's in multiple ways with small file sizes.

You might consider creating each 'customised' .pdf and then storing each of them in the cloud (www.Pogoplug.com gives 5Gb of free secure storage) and then simply providing the correct customised link within each Word document you send out to your end user!