New Contributor

Hi Community,


I have created a tool using macros in office 2016 however it is not running in 2010 version. Kindly suggest how can I run it in both. Please go through the code for your reference.


Sub Sent_Email()

Dim OAEmail As Outlook.Application
Set OAEmail = New Outlook.Application

Dim OAEmailItem As Outlook.MailItem
Set OAEmailItem = OAEmail.CreateItem(olMailItem)

OAEmailItem.To = Sheets("Email").Range("C8")
OAEmailItem.CC = Sheets("Email").Range("C9")
OAEmailItem.Subject = Sheets("Email").Range("C11")
OAEmailItem.Body = Sheets("Email").Range("C14") & vbNewLine & _
Sheets("Email").Range("C15") & vbNewLine & vbNewLine & _
Sheets("Email").Range("C16") & vbNewLine & vbNewLine & _
Sheets("Email").Range("C17") & vbNewLine & vbNewLine & _


End Sub

2 Replies


What happens when you run this? Do you get an error or what?

In the 2010 version file, did you add Reference to the Microsoft Outlook Object Library since you are using the early binding method?

Hi Subhodh,

Thank you for your reply, I got that error fixed however I need some addition on that file. I am not great in VBA. I have attached that file in a different discussion. Here's the link for it

It will great if you could help me with it.