How to Send Emails Directly from A Spreadsheet in Microsoft Excel

Excel is more than just a spreadsheet software—it also interacts with other applications like Outlook to send emails. Here's a simple, beginner-friendly guide on how to send emails directly from Excel.

1. Setting up Outlook

Before we start, ensure Microsoft Outlook is installed and set up on your computer since Excel utilizes Outlook's functionality for this task.

Check this link for guidance on setting up Outlook.

2. Preparing your Excel Spreadsheet

Ensure your spreadsheet has the necessary information such as recipient email addresses, subject lines, and email bodies.

3. Using VBA to Send Emails

1. Press Alt + F11 to open the VBA Editor.
2. From the "Insert" menu, select "Module". This creates a new module where you will write your code.
3. Paste the following code into the module:

Sub SendEmail()
    Dim outlookApp As Object
    Set outlookApp = CreateObject("Outlook.Application")
    Dim outlookMail As Object
    Set outlookMail = outlookApp.CreateItem(0)
    With outlookMail
        .To = "recipient@example.com" 
        .CC = "" 
        .BCC = "" 
        .Subject = "Your Subject"
        .Body = "Your Email Body"
        .Display 'Use this to display before sending, remove to send automatically
        '.Send
    End With
    Set outlookMail = Nothing
    Set outlookApp = Nothing
End Sub

Remember to replace "recipient@example.com", "Your Subject", and "Your Email Body" with references to the cells that contain this information.

For example, if the recipient's email is in cell A1, the subject in B1, and the body in C1, you would modify the code to:

.To = Range("A1").Value 
.Subject = Range("B1").Value
.Body = Range("C1").Value

This Microsoft page provides more details on automating mail from Excel using VBA.

4. Running the Code

To send the emails, go back to Excel and press Alt + F8, select SendEmail, and then click "Run".

Remember that Excel's ability to send emails from a spreadsheet using VBA could open up new possibilities, from sending personalized marketing communications to distributing regular reports. As always, ensure you're abiding by privacy regulations and using this functionality responsibly.