I'm using the following...
.Attachments.Add "\\Web\bass\pdf\" & [Msample] & ".pdf"
I would like to create an if statement for the attachment line.
If IsNull([Msample]) Then .Attachments.Add "\\Web\bass1\pdf\" & [Msample] & ".pdf" Else .Attachments.Add "\\Web\bass2\pdf\" & [Msample] & ".pdf"
Do I put the IF before the .Attachement or after or like I have it?
.Attachments.Add "\\Web\bass\pdf\" & [Msample] & ".pdf"
I would like to create an if statement for the attachment line.
If IsNull([Msample]) Then .Attachments.Add "\\Web\bass1\pdf\" & [Msample] & ".pdf" Else .Attachments.Add "\\Web\bass2\pdf\" & [Msample] & ".pdf"
Do I put the IF before the .Attachement or after or like I have it?