Hello,
I have an outlook email that has an embedded excel form. Part of the subject title is a string of # that must be changed before sending.
What replaces those #'s is also entered in a field of the form.

I would like to do 1 of 2 things (or both):
1. make sure the #'s are changed in the subject title before sending, and warn the user if they are not changed (or not let it be sent at all)
2. Have the part of the title that is manually replaced with # just be taken from the field below automatically

Is either of these possible in this application?

The form is also something that must be "activated" upon each use. Double clicking asks the user if they want to trust the form. I'm not sure if this can be changed to be something less annoying....

I appreciate any feedback, thanks!