Hi,



I am working on a company computer that has ridiculously restrictive settings, so I'm 100% certain there's easier ways to do this with add-ons (including Doug Robbins, but they've decided we can't use it anymore), but they won't let me download anything. I have the microsoft office package, stata & adobe to work with.

I need to insert a table with true conditional formatting (I have presented the highlighted solution suggested by macropod, but my boss wants it to be true shading, in the same way excel does it).

So I've figured out how to insert an excel table into word, but what I want to know is can I put individual tables into word using a mail merge field, as we do with the includepicture command?

Ideally, this is what would happen.

Step 1: MASTER SHEET: Use stata to combine multiple data sources into one excel spreadsheet. "ID" used as the ID for everything, in wide format. This includes 20 KPI metrics.
Step 2: INDIVIDUAL EXCEL TABLES: Excel sheet with conditional formatting and columns 1-3 prefilled with KPI benchmarks & definitions. Use stata to modify this document to create individual tables per person, by filling in row 4 from the master sheet with their personal KPI performance that shades based on the conditional formatting, and save each table as "ID.xlsx" in "tables_folder".
Step 3: MAIL MERGE: Using master sheet, which has ID as a column. Now here's bit
I don't know how to do {Include Table using "path\\<<ID>>.xlsx" }

Step 4: EMAIL: Email these personalised documents out using the Merge to Adobe PDF add-on, the only thing my IT dept would allow.


Please tell me there's a way to create this magic?