Sending object with Null Field

mercredi 11 mars 2015

I'm sending out an e-mail (see below). I want to add a cc addressee. However, sometimes the cc addressee will be blank. The e-mail works if the cc addressee field has data. It doesn't work if there isn't data. I tried an IIF statement but that didn't work. How do I can the object to work if the field is blank (null) or has data? Thanks





DoCmd.SendObject acSendNoObject, , acFormatTXT, Me.POCEmail, , Me.Email, , "Decoration Issue - Resolution Assistance", "Sir/Ma'am," & vbCr & vbCr & _

"We need your assistance in resolving the following decoration issue:" & vbCr & vbCr & _

"Issue/Necessary Correction: " & Me.Issue & vbCr & vbCr & _

"Member Information " & vbCr & vbCr & _

" " & Me.Grade & " " & Me.FullName & vbCr & _

" SSN: " & Format([SSN], "000-00-0000") & vbCr & _

" Unit: " & Me.Unit & vbCr & _

" E-mail: " & Me.Email & vbCr & vbCr & _

"Actions Taken:" & vbCr & vbCr & _

Me.ActionTaken & vbCr & vbCr & _

"vr" & vbCr & vbCr & vbCr & _

Me.TechTitle & " " & Me.FirstName & " " & Me.LastName & ", Cntr" & vbCr & _

"Awards and Decorations" & vbCr & _

"DSN 460-1633, Comm (229) 257-1633", True

Sending object with Null Field

0 commentaires:

Enregistrer un commentaire

Labels