Pull together various pieces of information to prepare email with attachment
I'm trying to get three pieces of information from Userform input / selection that will then populate an email with subject line, prepared body text and add a single attachment.
The RMS number will be typed in by the user, the Area selected from a combobox (this will provide the email address too) and the attachment located when clicking on a TextBox. Ideally, if it is possible, would like this to establish where the last document was saved and point to the folder containing it, ready for easy selection.