How to change where mail is sent from in excel

In Excel, you can change the "From" address in the email settings to send emails from a different email address. Here's how:

Method 1: Using the "From" field in the Email Settings

1. Open your Excel file and go to the "Data" tab in the ribbon.
2. Click on the "From" field in the "Email Settings" group.
3. Enter the new email address you want to use as the "From" address.
4. Click "OK" to save the changes.

Method 2: Using the "Mail" function

1. Open your Excel file and go to the cell where you want to send the email.
2. Type the following formula: =MAIL("Subject", "Body", "From Email Address", "To Email Address")
3. Replace "Subject" with the subject of your email, "Body" with the body of your email, "From Email Address" with the new email address you want to use, and "To Email Address" with the email address you want to send the email to.
4. Press Enter to send the email.

Method 3: Using VBA Macro

1. Open the Visual Basic Editor by pressing Alt + F11 or by navigating to "Developer" tab in the ribbon and clicking on "Visual Basic".

2. In the Visual Basic Editor, click on "Insert" > "Module" to insert a new module.

3. Paste the following code:

   Sub SendEmail()
    Dim olApp As Object
    Dim olMail As Object
   
    Set olApp = CreateObject("Outlook.Application")
    Set olMail = olApp.CreateItem(0)
   
    With olMail
       .Subject = "Your Email Subject"
       .Body = "Your Email Body"
       .From = "Your New Email Address"
       .To = "Recipient's Email Address"
       .Send
    End With
   
    Set olMail = Nothing
    Set olApp = Nothing
   End Sub

4. Replace "Your Email Subject", "Your Email Body", "Your New Email Address", and "Recipient's Email Address" with your desired values.

5. Click "Run" to send the email.

Note: Make sure you have Outlook installed on your computer and that the email address you want to use as the "From" address is a valid Outlook account.