vierlami
asked on
Send data entered in Excel user form to Outlook
I have an Excel user form that I want the user to fill in and be able to press a command button (Submit for approval) on the form to create an Outlook email where they can then enter their supervisors email address once the email with the data from the form is created. All fields are text with the exception of a date picker. I have a separate command button that saves the record to another tab. Any assistance appreciated.Excel-User-Form.xlsmI have an Excel user form that I want the user to fill in and be able to press a command button (Submit for approval) on the form to create an Outlook email where they can then enter their supervisors email address once the email with the data from the form is created. All fields are text with the exception of a date picker. I have a separate command button that saves the record to another tab. Any assistance appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thankyou for the points.
Please post back in this thread if you have any problems with the code.
Goodluck
Rob
Please post back in this thread if you have any problems with the code.
Goodluck
Rob
ASKER