Send mail from excel with functions

0

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

Answer
Discuss

Answers

0

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
Discuss

Discussion

With functions only 
beepetark Nov 11, '19 at 12:38 pm
UDF ??
k1w1sm (rep: 197) Nov 11, '19 at 2:06 pm
You will need a macro/vba to do what you want. 
don (rep: 1725) Nov 12, '19 at 3:33 am
Only functions
No VBA,macros 
beepetark Nov 23, '19 at 1:49 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login