#1
|
|||
|
|||
Merging one of two fields, but they could be blank
I'm trying to use mergefield to create a label for our boxes.
On the label we have a spot for our customer's PO number (Purchase Order). One issue is that we do work for brokers and they want their customer's PO on the label. The last thing is sometimes we don't get a PO number at all. We want to show the SubCustomerPO, but if it's blank we would then show the CustomerPO. We would not show both SubcustomerPO and CustomerPO. If they are both blank, we don't want to show anything. I can get either to show, but if they are both blank, I still get a blank line on the label. Someone gave me this, but it shows "PO: " if both fields are blank: { if{ MERGEFIELD "SubCustomerJob"}="" "PO#:" "{ MERGEFIELD"SubCustomerJob" } "} { if{MERGEFIELD "SubCustomerPOJob" }="" "{MERGEFIELD CustomerPO }" "{MERGEFIELD "SubCustomerPOJob" }" } I also tried this, but it shows a blank line if both fields are blank: { if { MERGEFIELD "SubCustomerPOJob" } = "" { SET LabelPO{ MERGEFIELD "CustomerPO" }}{ SET LabelPO {MERGEFIELD "SubCustomerPOJob" }}}{ if { REF LabelPO } = "" "" "PO: " }{ REF LabelPO } I'm sure I've overlooked what I'm supposed to do in everything I've read, but I haven't been able to find it. Any help is appreciated. Thanks Ron |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MailMerge Displaying Blank Fields in Emails | constructionjasont | Mail Merge | 5 | 06-10-2019 06:13 AM |
Exlude Blank Fields using MIN in an ARRAY | TomSv | Excel | 6 | 04-12-2016 04:47 PM |
Merging multiple fields within a Word letter from Excel | LindsayV | Mail Merge | 2 | 04-08-2016 07:17 AM |
Word does not put the files in the outbox of Outlook (merging with excel fields) | Pannemanski | Mail Merge | 1 | 04-08-2016 03:58 AM |
merging text into blank rolodex document | Saloei | Word | 0 | 01-31-2009 05:23 AM |