combining different Mail Merge Word files and generate into 1 pdf file

[derricklo1980]

Hi,

I want to combine several Word mail merge files and save as 1 pdf file as an output. I am thinking to do it in Word macro/VBA.

Basically, I have a few Word template letters, each with a data source excel file (i.e. n Word files & n Excel files). For each Word template letter, it will have several records (and thus letters) depending on the number of records in its associated Excel file. I want to print all of these letters (from different Word Templates) either in simplex or duplex, and save as 1 single PDF file.

How to do it?
Thanks!

 

[SkipVought]

hi,

Please stated the process by which you currently accomplish this task.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

that is, please state the process by which you currently accomplish this task.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[derricklo1980]

Hi Skip,

So far I have no problem in mail merge a Word template using a data source Excel file and print all the letters of that Word template out (I can easily achieve that by recording a marco in Word and edit it via VBA).

But I have no idea how to call a Word template, mail merge by calling its excel file, save the letters into a temp file; call another Work template and Excel file, save and append those letters to the end of the temp file; repeat the process and eventually got a combined file with all the letters of different templates and save as a PDF file...

I am stuck in how to achieve combining different Word templates' letters into 1 PDF file

 

[SkipVought]

I have never tried using two different templates. What is the purpose of two templates. Can a single template be created to avoid using two templates?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[derricklo1980]

Hi Skip,

There are different letter templates send to customers for different purposes. The purpose is to combine all letters from different templates into 1 PDF file and send to print house to print.

Single template might not cater the requirement as each template will print different number of record (e.g. data source of Template A may have 10 records while data source of Template B may have 20 records) ...

 

[SkipVought]

So is this a ONE TIME thing?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[macropod]

You could, of course, execute the merges to indivdual PDF output files first, then combine them as required afterwards.

The better way, though, is to combine your two mailmerge main documents first, so that only one PDF file per record is produced. The limitation, though, is that the mailmerge main documents would have to use a common data source.

There are free utilities available on the web for doing the individual letters (eg

http://www.gmayor.com/individual_merge_letters.htm).

Cheers
Paul Edstein
[MS MVP - Word]