Thread: [Solved] If Statement with "and" and "Or
View Single Post
 
Old 05-18-2018, 03:33 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit 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
Are the braces (i.e. {}) in your attachment present in the actual workbook you're using for the mailmerge?

As for:
If {Rep} <> "" And {Rep} has data
that's the same as:
If {Rep} <> ""
since <> "" means there must be data whenever the test evaluates to TRUE...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote