#1
|
||||
|
||||
Adjusting Layout with Varying # Mail Merge Variables
Greetings all,
A friend is producing a report for different countries showing what diseases exist in each country. I think a mail merge might work, but we will want to list information only about diseases that are present in a given country. Right now, we have blank / null cells in our Excel spreadsheet for non-present diseases. Each disease has a handful of related variables, some of which contain info specific to the countries. Essentially, we’d like to collapse the display of any missing data fields (and its accompanying table) so that only relevant data is shown. So if we had three diseases total (A, B, C) and only two were present in a country (A & C), we’d like to produce: Table. Disease A Info, data in table Table. Disease C Info, data in table How might I accomplish this with Word? Any ideas? Many thanks in advance for the help! Sincerely, Eric Edit: Another way of asking the question might be: how could I hide empty tables automatically in Word? These reports will be printed out to PDFs. |
Tags |
mail merge |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Directory Mail Merge with table layout | 3N1GM4 | Mail Merge | 11 | 06-03-2014 09:54 PM |
Mail Merge to email, changing images on email layout | ginelli | Mail Merge | 18 | 02-23-2013 09:47 AM |
Conditional merge fields in mail merge | Aude | Mail Merge | 1 | 01-06-2012 07:38 PM |
Mail merging and pulling varying data from Excel | shannag1881 | Mail Merge | 0 | 10-05-2009 08:51 AM |
varying orientation on a multi-page document??? | imimin | Word | 1 | 08-24-2009 12:12 PM |