Sending Email From Excel UserForm Using Dependent Cell Data
<p>Our employees require bi-annual certifications.  The employee name certification dates, and upcoming certification date are kept in a master spreadsheet.  From this spreadsheet, you can open a userform to send an Outlook appointment for the date of certification.  In the UserForm, you select the employee you want t o send the certification for.  My question is this:  The date of the appointment is dependent upon which employee you select?  What code do I use, that will search the matrix for the correct employee name in column B, and use the date in column H of the corresponding row? I am currently this far in the process: </p>

<pre><code>Dim Otlk 'As Outlook.Application
Dim Appt 'As Outlook.AppointmentItem
Const olAppointmentItem = 1
Const olMeeting = 1
    Set Otlk = CreateObject("Outlook.Application")
    Set Appt = Otlk.CreateItem(olAppointmentItem)

'30 Day Invite
With Appt
    .Subject = Me.Employee1ComboBox.Value &amp; " " &amp; "Cft Certification"
    .Start = 
</code></pre>

<p><img src="https://i.stack.imgur.com/ZcTsK.png" alt="enter image description here"></p>