200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Dear All,
I like to ask that how can v send mails to concerned mail id with one click with functions only
Example
With subject and body of the letter
From:xyz@abc.com
To: manger@abc.com
Cc:sales manager@abc.com
Bcc: salesTL@abc.com
Subject: congrats
Body of letter:
Congrats u (employee name) have reached target with in time
From
MIS COORDINATOR
Then I have to click send
That's it
No, you need a macro to do this.
Here is a tutorial I made for this that walks you through it: Send Email from Excel
Here is the most basic macro from that tutorial:
Sub Email_From_Excel_Basic()
' TeachExcel.com
Dim emailApplication As Object
Dim emailItem As Object
Set emailApplication = CreateObject("Outlook.Application")
Set emailItem = emailApplication.CreateItem(0)
' Now we build the email.
emailItem.to = "email@test.com; email2@test.com; anotheremail@test.com"
emailItem.Subject = "Subject line for the email."
emailItem.Body = "The message for the email."
' Send the Email
' Use this OR .Display, but not both together.
emailItem.Send
' Display the Email so the user can change it as desired before sending it.
' Use this OR .Send, but not both together.
'emailItem.Display
Set emailItem = Nothing
Set emailApplication = Nothing
End Sub