I am trying to include the value from a text box on a report in the subject line of an email. Can anyone tell me why this does not work.
Set oOutlook = New Outlook.Application
End If
Set oemailItem = oOutlook.CreateItem(olMailItem)
With oemailItem
.Subject = [Reports]![Name of Report]![Textbox] & " : " & "Additional string"
.Body = "String for body of email:"
.Attachments.Add filepath
.Display
End With
Thank you