Have a button on form to send an email. All the fields (To, CC, Body text) get filled in for the outlook message except the subject. I stepped through the code and hovered over the field going into the subject and it contains data. Did I miss something or is there a typo?
Code:
With MailOutLook
.BodyFormat = 3 'Late binding in lieu of olFormatRichText
.To = ConcatRelated("email", "tblEmail", "distributiontype='To'", , ";") '"me@myemail.com"
.CC = ConcatRelated("email", "tblEmail", "distributiontype='cc'", , ";")
'.bcc = ""
.Subject = Me.txtUCASEFilename
.HTMLBody = stBody & "<br>" & Signature
'.Send
.Display 'Use for testing in lieu of .Send
End With