Thanks for all your help up to this point.
I'm trying to send an email with just a button click, I followed the directions in the video to send with Outlook.
When I click the button, I get the Outlook send email tab, but the send to is blank. I have to enter it manually, and the first name does not appear. What am I doing wrong?

This is the code that I have

Details

Private Sub SendEmailBtn_Click()
    Dim Msg As String
    
    Msg = "Attention " & FirstName & ",

"
    
    Dim O As Outlook.Application
    Dim M As Outlook.MailItem
    
    Set O = New Outlook.Application
    Set M = O.CreateItem(olMailItem)
    
    With M
        .BodyFormat = olFormatHTML
        .HTMLBody = Msg
        .To = Email
        .Subject = " Please Review and Reply if necessary"
        .Display
    End With
    
    
    Set O = Nothing
    Set M = Nothing
    
End Sub
Copy

Thank you