Macro to send a mail to outlook

  • Thread starter Thread starter mailmeindeed
  • Start date Start date
M

mailmeindeed

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: A1>20 then send the mail
to a person mentioned in the Cell B2.
 
===================================
Sub Naveen2()
If Range("A1") > 20 Then
ActiveWorkbook.SendMail Recipients:=Range("B1")
End If
End Sub
===================================

*** Please do rate ***
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to create a macro 2
Macro to use information in a cell to locate and send files using outlook 0
Excel Send Lotus Notes Mails With VBA Macro Excel 0
Macro to insert pictures in comments 8
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel Macro to creat & send email 2
Net Send to Many by macro 2
Macro to send email automatically. 3

Back
Top