Thread: [Solved] Yes/No field does not work in mailmerge
View Single Post
 
Old 10-13-2013, 02:34 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Hi Brenda,

Instead of:
{IF{MERGEFIELD Buyer2Name}<> " " {IF{MERGEFIELD Buyer3Name}<> " " ", " " and " } ""}
you might be able to use field coding like:
{IF{MERGEFIELD Buyer2Name }= "??*" {IF{MERGEFIELD Buyer3Name}= "??*" ", " " and "}}
Basically, the above field code tests whether the mergefields contain at least two characters (on the assumption you don't have any one-character buyer names).

I doubt MS has any plans to update DDE and, even if they did, there's no reason to suppose it would fix this problem.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote