email address blank

[smartglass]

Hi:
Still using a variant of the magnificent thread401-249399 to email reports, I populate the email address with field data. What I am trying to do now is warn the emailer when the field is blank; along the lines of "If strRcp is blank then (message or report) else send"...but I am not getting very far.
Has anybody come across a solution to this ?
Thanks in advance!

 

[smartglass]

I apologise: I have fixed it. Because it was a string, then I used the Len to give me a number, then read from the number as follows:
count = Len(stRcp)
if count >1 then....
else
ImpRep.CloseReport
Set ImpRep = Nothing
MsgBox "There is no email address!