Forum Discussion

mzeller1776's avatar
mzeller1776
Copper Contributor
May 09, 2025
Solved

VBA to include form field value in email

I have a form. On that form, one of the fields that a user fills out is called SRNumber (displayed on form as SR#). I have a control button at the bottom of the form. When the info is complete the users clicks the control button. This sends an email to another user. This is working fine. But in the email to goes out I'm wanting to include the value of the SRNumber field. Thought this would be easy to do. My email goes out and my body message displays but does not display the value of the SRNumber field at all. Any ideas? Below is the form field in design mode, the email message I receive, and the vba code.

 

And yes, I entered something in the SR# box. Which is 12345.

  • It should work - I tested it:

    Are you sure that the text box is really named SRNumber? (And that is a text box)

Resources