|
|
#1
06-24-2019, 08:12 PM
|
|||
|
|||
Populating Tables with data when available only - Using Mail merge
Hi, I am trying to create a table where I show the Name of the PORTFOLIO on one column, the ASSET CLASSES on the second column and TARGET value for each asset class. I have attached the data, and the output I want from a mail merge on a word document. The challenge I have with my data is some PORTFOLIOS do not have all the ASSET CLASSES and their TARGET VALUE. How can I run a mail merge in a way that the table will not show ASSET CLASSES with ZERO values? If you see the excel spreadsheet you will understand what I am referring to. How can I overcome this to effectively carry out a mail merge as shown in the output sheet? Thanks! John 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Mail Merge does not split tables if entry has a number in front
|
B-Man | Mail Merge | 5 | 05-19-2019 07:25 AM |
| Mail Merge Field Not Populating | JennEx | Mail Merge | 3 | 05-10-2015 09:30 PM |
| Is data merge and mail merge the same thing? | ikearns | Mail Merge | 1 | 09-12-2014 03:53 AM |
| Tables not populating properly from code | DepricatedZero | Word VBA | 1 | 06-04-2013 06:22 AM |
| mail merge from access query or two tables | peter | Mail Merge | 0 | 08-24-2010 05:32 PM |
Windows 10 
Office 2007
Threaded Mode