Mail Merge in table and conditional formating

%3CLINGO-SUB%20id%3D%22lingo-sub-304871%22%20slang%3D%22en-US%22%3EMail%20Merge%20in%20table%20and%20conditional%20formating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304871%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20trouble%20with%20a%20table%20that%20has%20mail%20merge%20fields%20in%20it.%20%26nbsp%3BI%20figured%20it%20out%20before%20some%20time%20ago%20but%20I%20can't%20remember%20how%20it's%20done.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%3A%3C%2FP%3E%3CP%3EIn%20the%20table%20cell%20there%20is%20a%20mail%20merge%20field%20from%20an%20excel%20sheet.%20%26nbsp%3BIf%20there%20is%20no%26nbsp%3Bvalue%26nbsp%3Bin%20the%20excel%20cell%26nbsp%3BI'd%20like%20to%20return%20a%20'No%20result%20given'%20in%20the%20word%20table.%20%26nbsp%3BAt%20the%20moment%20it's%20giving%20me%20a%20zero%20value.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20assuming%20its%20conditional%20formatting%20of%20a%20kind%20but%20I%20can't%20figure%20out%20how%20to%20do%20it.%3C%2FP%3E%3CP%3EAll%20help%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-304871%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWord%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-305254%22%20slang%3D%22en-US%22%3ERe%3A%20Mail%20Merge%20in%20table%20and%20conditional%20formating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-305254%22%20slang%3D%22en-US%22%3EGlad%20to%20hear!%3CBR%20%2F%3E%3CBR%20%2F%3E%2Fadam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304916%22%20slang%3D%22en-US%22%3ERe%3A%20Mail%20Merge%20in%20table%20and%20conditional%20formating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304916%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Adam%2C%20I%20think%20I've%20just%20about%20figured%20it%20out%20-%20by%20chance%20more%20than%20anything!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304911%22%20slang%3D%22en-US%22%3ERe%3A%20Mail%20Merge%20in%20table%20and%20conditional%20formating%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304911%22%20slang%3D%22en-US%22%3EMake%20sure%20to%20post%20this%20in%20the%20excel%20forum%20as%20well!%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E
Contributor

Hey guys,

 

I'm having trouble with a table that has mail merge fields in it.  I figured it out before some time ago but I can't remember how it's done.

 

The problem is:

In the table cell there is a mail merge field from an excel sheet.  If there is no value in the excel cell I'd like to return a 'No result given' in the word table.  At the moment it's giving me a zero value.  

 

I'm assuming its conditional formatting of a kind but I can't figure out how to do it.

All help appreciated!

3 Replies
Make sure to post this in the excel forum as well!

Adam

Thanks Adam, I think I've just about figured it out - by chance more than anything!

Glad to hear!

/adam