Hello – Here is an IIf statement I am currently using to add a cc: to a report/letter only if that addressee (O) is not blank:
=IIf([O-LastName] Is Null," ",Trim("cc: " & [O-Prefix] & " " & [O-FirstName] & " " & [O-LastName] & " " & [O-Suffix] & ", " & [O-Company]))
I’d like to also have the letter cc: stay blank if another condition is true - it is a yes/no check box labeled “O-D Same” So if “O-LastName” is blank, leave the cc: blank, but also if the “O-D Same” box is checked (yes/true), leave the cc: blank. How do I add this? Thank you!