View Single Post
Old 06-24-2019, 08:12 PM
stevejohhnym stevejohhnym is offline Windows 10 Office 2007
Join Date: Jun 2019
Posts: 1
stevejohhnym is on a distinguished road
Default Populating Tables with data when available only - Using Mail merge


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?

Reply With Quote