JitendraKushwah
New Member
Hi Friends,
I am having problem in Excel VBA code for mac system. The actual requirement is active workbook will attached in mail(As Draft). But we could not do in vba. Even though I already done this task for windows. therefore I need for your help or suggestion. For the reference I am attaching below window Vba Code.
I am having problem in Excel VBA code for mac system. The actual requirement is active workbook will attached in mail(As Draft). But we could not do in vba. Even though I already done this task for windows. therefore I need for your help or suggestion. For the reference I am attaching below window Vba Code.
Code:
Sub AttachFileToEmail()
Dim OutApp As Object
Dim OutMail As Object
'Set OutApp = CreateObject("Outlook.Application")
'Set OutMail = OutApp.CreateItem(0)
ActiveWorkbook.Save
On Error Resume Next
ActiveWorkbook.SendMail "jitendra.kushwah@actiknow.com"
With OutMail
.To = "vinay.singh@actiknow.com"
.Subject = "Memphis COD Order"
.Attachments.Add ActiveWorkbook.FullName
.Display
End With
Set OutMail = Nothing
Set OutApp = Nothing
End Sub
Last edited by a moderator: