Link to home
Start Free TrialLog in
Avatar of vierlami
vierlamiFlag for United States of America

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
Avatar of Rob Brockett
Rob Brockett
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vierlami

ASKER

Thank you for the quick response. I am still learning, so this will help me learn. I will modify the code and change the ranges to the fields on my user form.
Thankyou for the points.

Please post back in this thread if you have any problems with the code.

Goodluck
Rob