Hi, I am still very new to VBA and therefore would like to pool in the help from all of the experts here.
I have attached my report and there is a userform.
My idea is that when user enters their name and leave days. The necessary info will be shown in the controls on the userform.
I want to send an email to the approver listed in my control label - Label11.
I don't know how to code to pull the data from the label field to dynamically send the outlook email to the appropriate approver listed on my form.
Also , I want a standard email body to be sent capturing the leave applicant's name, days of leave applied etc. All these are capture on my userform as they apply. How can I code them
so that i automate the sending of emails.Thanks for the help!
Individual Leave Report Test.xlsm
Bookmarks