Best way of automating a mailshot process

Question

I looking at automating a mailshot process. Currently the mail merge is done in word with data coming from SQL Server. This produces a letter, then depending on a value on the letter a number of brochures are manually added to the envelope with the letter. What I am trying to do, is automatically print the correct number of pdfs behind the letter. For example when the merge is run and the first letter has a PDFCount (field from the query) of 3, the letter is printer and then 3 pdfs are printed before the next letter. Whats the best way of achieving this?

Answer 1

The best way I could find to sort this, was to convert the PDF to word, and insert the brochure into the the mailmerge when needed