#1
|
|||
|
|||
Inserting a table as a mergefield, similar to INCLUDEPICTURE
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? |
Tags |
conditional formatting, mergefield, table |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
IncludePicture with Mergefield | paluccie | Mail Merge | 3 | 03-13-2021 06:34 AM |
syntax for inserting blank line before inserting table and after a line or paragraph | SamDsouza | Word VBA | 8 | 08-04-2019 11:10 PM |
Blank Rows in Table populated through Conditional IF statemement MergeField options in Word | gideonpm | Mail Merge | 3 | 12-22-2016 01:20 PM |
a table pasted in word from excel is not similar to the original table in excel | Mukapa | Word Tables | 1 | 01-18-2016 07:31 AM |
Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL | Richard.p | Word | 3 | 04-21-2015 01:14 AM |