How to send email based on cell value?

How to send email based on cell value?

The following is a step by step guide on how to send an email based on cell value using Microsoft Excel. Step 1. Open Microsoft Excel and then open the worksheet you need to send the email based on its cell value. In this example we are using the D7 cell, right click the sheet tab and then select View Code.

How to send an email based on a D7 cell?

With the code in place whenever the value of the D7 cell is higher than 200, an email for the intended recipient will be created automatically using Microsoft Outlook. You can click the Send button to send it. You should see something like this. Note of caution.

Is there a way to automatically send an email from Excel?

Step 3. Now, you should press Alt + Q keys together to close the Microsoft Visual Basic for Applications window. With the code in place whenever the value of the D7 cell is higher than 200, an email for the intended recipient will be created automatically using Microsoft Outlook. You can click the Send button to send it.

How do I send an email from Visual Basic?

Now, you should press Alt + Q keys together to close the Microsoft Visual Basic for Applications window. With the code in place whenever the value of the D7 cell is higher than 200, an email for the intended recipient will be created automatically using Microsoft Outlook. You can click the Send button to send it. You should see something like this.

How to send email if a certain cell is modified in Excel?

Please change the email body as you need in xMailBody line in the code. 3). Replace the Email Address with the recipient email address in line .To = “Email Address”. 4). Change the email subject in line .Subject = “Worksheet modified in ” & ThisWorkbook.FullName.

Can you change the range of a cell in outlook?

If you want the code to work for another cell or more cells you can change the range in the event. Test this example macro to create/display a Outlook mail with a small text message. You must copy this macro in a standard module and not in the worksheet module, see this page how.