View Single Post
Old 05-08-2014, 10:32 AM
dsummers dsummers is offline Mac OS X Office for Mac 2011
Join Date: May 2014
Posts: 1
dsummers is on a distinguished road
Default Mail merge how to link mail merge field value to a column heading

Hi, I'm creating some labels for delivery boxes and thought that mail merge would be the way forward. My labels contain i) the delivery details (name, address, postcode) and ii) the names of the items in the box and the volume.

I have managed to achieve this but, in the example attached, where I have '0' volume for a particular box item I don't want that item to be displayed at all, e.g. in the bread section if 'Fig & Red Wine' is '0' then I want to find a way of not returning the hardcoded text.

I've tried fiddling around with IF statements and switches but can't get anything to work. Is there a way of inserting the column headings as merge fields and then making their appearance contingent on the existence of values other than 0 in my data?

Your help would be greatly appreciated.

Kind regards
Attached Files
File Type: xlsx Mailmerge source data test 2.xlsx (47.9 KB, 11 views)
File Type: docx Mailmerge test doc 2.docx (93.6 KB, 6 views)
Reply With Quote