Report automation

[falkuwari]

Hi all,

I'm generating wellness reports for a project. I have around 1000 report (80 pages each) in PDF format. I currently use acrobat to manually generate or edit reports and it is consuming in every possible way!

In the report we have 30 traits that we test for, and each trait has it's own results page. Attached, you can find the page layout for the results page. Can you please recommend the most simple way to automate reports generation given that I have no experience with scripting.

Thank you!

 

[Macropod]

If the reports have common core content and something that can be used to determine the variable content for each report is stored in a database or Excel workbook with a table structure, mailmerge may prove a suitable tool. For the basics, see:

Mail merge using an Excel spreadsheet - Microsoft Support

How to use an Excel spreadsheet with mail merge in Word to create mailing lists for labels, envelopes, and documents.

support.office.com

For some VBA code that automates a mailmerge to generate a separate report for each recipient (plus lots of other useful mailmerge stuff), see Send Mailmerge Output to Individual Files in the Mailmerge Tips and Tricks thread at:

Mailmerge Tips & Tricks

[Solved] Mailmerge Tips & Tricks Mail Merge

www.msofficeforums.com