I need help with the syntax for an if statement!
If pubEmailAddress <> "No Valid Email Address" Or pubEmailAddress <> "No Email Address" Then
......
Else
.......
End Id
So if pubEmailAddress = "an email address" then the code must run before "Else"
If pubEmailAddress <> an email address, then the code must run after "Else"
What is the correct syntax for the first line in the if statement?
I suppose I could use an ElseIf but I am hoping not too!
Many thanks
If pubEmailAddress <> "No Valid Email Address" Or pubEmailAddress <> "No Email Address" Then
......
Else
.......
End Id
So if pubEmailAddress = "an email address" then the code must run before "Else"
If pubEmailAddress <> an email address, then the code must run after "Else"
What is the correct syntax for the first line in the if statement?
I suppose I could use an ElseIf but I am hoping not too!
Many thanks