Hello all,
I am attempting to distribute an entry form in a way that from within the file itself, entrants can click a button and send the current state of their file to me.
In cell a2 they type their name
In cells B2:B6 they select their choices via a dropdown menu
In cell C2 they enter an integer value
I would like the email to be sent to a consistent email address and the name of the file to be based on their name. I would like only cells A1:C6 be sent from Sheet 'Entry Form' if possible. If not, the entire 'Entry Form' sheet is fine.
I am new to VBA, and could really use some assistance with this.
Thank you,
Tim
I am attempting to distribute an entry form in a way that from within the file itself, entrants can click a button and send the current state of their file to me.
In cell a2 they type their name
In cells B2:B6 they select their choices via a dropdown menu
In cell C2 they enter an integer value
I would like the email to be sent to a consistent email address and the name of the file to be based on their name. I would like only cells A1:C6 be sent from Sheet 'Entry Form' if possible. If not, the entire 'Entry Form' sheet is fine.
I am new to VBA, and could really use some assistance with this.
Thank you,
Tim
