Hi - Really struggling to find the answers to multiple problems this afternoon, and my latest conundrum is as follows (I'd appreciate any help anyone can throw my way):

Here is my code for generating and populating an email with data from Excel... This works fine:

Sub SendEmail()
'Automatically creates an new email, populated with relevant data from the spreadsheet'

Dim OApp As Object, OMail As Object, signature As String
Set OApp = CreateObject("Outlook.Application")
Set OMail = OApp.CreateItem(0)
    With OMail
    .Display
    End With
    
    With OMail
    signature = OMail.body
    
    .ReadReceiptRequested = True
    .To = Range("F2")
    .Importance = 2
    .Subject = "Call Coaching Feedback"
    
    .body = "Hi" & " " & Range("P131") & vbNewLine & vbNewLine _
    & "Here is the feedback from the call I have assessed for you today..." & vbNewLine & vbNewLine _
    & "Date of Call:" & " " & Range("AB6") & vbNewLine _
    & "Time of Call:" & " " & Format(Range("AB8"), "hh:mm:ss") & vbNewLine & vbNewLine _
    & Range("O63") & vbNewLine & vbNewLine _
    & "If you have any questions regarding the above, or would like to discuss anything further, please let me know." & vbNewLine & vbNewLine _
    & "Regards," & vbNewLine & vbNewLine _
    & Range("W131") & signature
    .Display
 
    
    End With
    
Set OMail = Nothing
Set OApp = Nothing

End Sub
What I would like to happen, is that when the "To" field of the new message is populated with the contents of "F2" (i.e. "John Smith") the "Check Names" function of Outlook is automatically triggered so that the Global Address List pops up (if multiple people called John Smith are found) etc.

Is this possible?

Thanks,
PAS