Sending an excel form by email using VBA

[Papa C]

I am a novice with VBA. I need help getting an excel form to be sent by email once it is completed and saved. The form has multiple drop downs and I would like to use the reference cells in sending the email. I currently have 3 working macro's that name and save the file. A macro that clears the contents in the form after it is saved so it can be used again. And another macro that deletes any text boxes that were added to a site map. I would like to send an email to the email address in "F4" once everything is completed. The Drive in red is where the form is stored (it is stored in a file based on the property in "C4"). I have tried multiple macros but none seem to work. I never get an email nor does it indicate any errors.
Let me know if this is enough information.

 

[Logit]

It can be done either way.

This line of code .... .Display will display the email first to allow for edits, then the email must be sent manually.

If you discard .Display and replace it with .Send ... the email will be sent automatically.

In either case you'll need the old version of OUTLOOK installed on your machine. The new version of OUTLOOK does not allow for
send emails via VBA code. Depending on the machine ( don't understand the following), sometimes OUTLOOK must be running before
running the email macro.