How to Create New Outlook Email Through Excel VBA?

Please copy paste the below code in to your "Module" and save it (change the content and address details as per your requirement). Assign a Button to that macro and click run. There you go.

(I have provided complete details how each one of the lines is working in VBA in the below codes itself. Once you pasted those details into the Module comments will be highlighted in green)

For your note we have not used any References to this Outlook Macro to run. This is called "Late Binding", which means we directly creating outlook application/mail item without altering or adding any References relating to Outlook in VBA editor. We are just directly telling to VBA to open outlook application through the below details

'Use the below code to Minimize/Maximize the Outlook mailtiem window

Sub CreateNewMail()
 Set OutApp = CreateObject("Outlook.Application")  '-------- Create Outlook application if not open already
 Set OutMail = OutApp.CreateItem(olmailitem) '---------Create new mail item to write a content you want
    
'----------------------Creating content in a New Mail ------------------------
    
    With OutMail '-----what are the actions you are going to perform with the new items will go here
        .to = "name@domain.com"  '---- Provide your To address details here.
        .cc = "name1@domain.com"  '---- Provide your CC address  details here.
        .bcc = "name2@domain.com"   '---- Provide your BCC address details here if required.
        .Subject = "Test"   '---- Provide your Subject Details here.
        .body = "Testing the mail"   '---- Write your content whatever you want to send.
        
'----------------------Send you Mail ------------------------
        .Display  '-------- This step will Display the mail item (Optional)
        .send   '----- This will send the mail item also it prompts security popup window. Once click "Allow" the message will go.
             
    End With

End Sub

Thanks for the visit.