Subject not showing up in Outlook

sxschech · Jul 31, 2018

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

NauticalGent · Jul 31, 2018

Hello sxschech,

Out of sheer curiosity, have you tried a debug.print .Subject right after you assigned it a value? If it actually shows that it has been assigned then I have no idea what the issue is.

sxschech · Jul 31, 2018

Added a debug.print as suggested and showed nothing in the immediate window for subject while textbox's text shows up. Also did a len on them and that shows as 0 in immediate window for subject and 48 for textbox.

Code:

 .Subject = Me.txtUCASEFilename
        .HTMLBody = stBody & "<br>" & Signature
        '.Send
        Debug.Print "txtBox " & Me.txtUCASEFilename
        Debug.Print "len txtbox " & Len(Me.txtUCASEFilename)
        Debug.Print "Subj " & .Subject
        Debug.Print "len subj " & Len(.Subject)

NauticalGent · Jul 31, 2018

That IS strange...no idea what the issue is. Are you able to “hard code” the subject. In other words populate it with a literal? If so, then you might fare by assigning the value to a string first and then setting the subject to that string?

The only other thing I could fathom is that maybe becuase the record has not been updated/saved prior to shelling out to Outlook, the value is not getting “pushed”.

sxschech · Jul 31, 2018

assigning the value to a string first and then setting the subject to that string

That worked. Thanks much.

NauticalGent · Jul 31, 2018

Glad it worked, who knew??!

sxschech · Jul 31, 2018

You did...

Frothingslosh · Jul 31, 2018

My guess is that it was trying to assign the OBJECT txtUCASEFilename to the Subject property. Something else that may have worked is

Code:

Me.txtUCASEFilename.Value

VBA is odd like that - sometimes it thinks you're assigning the object, not the value of the default property (which is what the Value property actually is). I run into that all the time when I'm assigning values to TempVars.

NauticalGent · Aug 1, 2018

Figured there was a logical explanation. My first inclination always involves voodoo and midnight sacrifices...

Subject not showing up in Outlook

sxschech

Registered User.

Attachments

NauticalGent

Ignore List Poster Boy

sxschech

Registered User.

NauticalGent

Ignore List Poster Boy

sxschech

Registered User.

NauticalGent

Ignore List Poster Boy

sxschech

Registered User.

Frothingslosh

Premier Pale Stale Ale

NauticalGent

Ignore List Poster Boy

Similar threads

Users who are viewing this thread