ExcelBanter - Macro to send a mail to outlook

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Macro to send a mail to outlook (https://www.excelbanter.com/excel-discussion-misc-queries/106833-macro-send-mail-outlook.html)

[email protected]

Macro to send a mail to outlook

Hi all,

I need a macro to send the amail to the user mentioned in the excel
sheet, if the value is true in the cell. Eg: A120 then send the mail
to a person mentioned in the Cell B2.

Naveen

Macro to send a mail to outlook

===================================
Sub Naveen2()
If Range("A1") 20 Then
ActiveWorkbook.SendMail Recipients:=Range("B1")
End If
End Sub
===================================

*** Please do rate ***

" wrote:

Hi all,

I need a macro to send the amail to the user mentioned in the excel
sheet, if the value is true in the cell. Eg: A120 then send the mail
to a person mentioned in the Cell B2.

All times are GMT +1. The time now is 04:49 PM.