Sub sendMail
Dim outApp As New Outlook.Application, outMail As Variant,mailId as String
Set outMail = outApp.CreateItem(olMailItem)
With outMail
.To = mailId
.Subject = Mid(wb.Name, 1, InStr(wb.Name, ".") - 1)
.Body = "Hi," & vbNewLine & " Please find the attachment" & vbNewLine & "Regards," & vbNewLine & "Soumyendu"
.Attachments.Add (wb.Path & "\" & wb.Name)
.Display
End With
wb.Close
End sub
Dim outApp As New Outlook.Application, outMail As Variant,mailId as String
Set outMail = outApp.CreateItem(olMailItem)
With outMail
.To = mailId
.Subject = Mid(wb.Name, 1, InStr(wb.Name, ".") - 1)
.Body = "Hi," & vbNewLine & " Please find the attachment" & vbNewLine & "Regards," & vbNewLine & "Soumyendu"
.Attachments.Add (wb.Path & "\" & wb.Name)
.Display
End With
wb.Close
End sub
No comments:
Post a Comment