SendObject

[James Petersen]

I use SendObject to send e-mail. If I refer to a field that's blank (e.g., EmailAddress), the e-mail isn't built (error). I tried using nz(field) but without success. Is there an easy fix for this?

 

[HiTechCoach]

It is Best Practice to first validate that the email exists before executing the sendobject.


Psuedo code:

If Nz(Me.MyEmailAddressControl,"") > "" Then

Docmd. SendObject ...

End If