Dim aOutlook As Outlook.Application, aEmail As Outlook.MailItem
Set aOutlook = GetObject(, "Outlook.Application"
If aOutlook Is Nothing Then Set aOutlook = New Outlook.Application
Set aEmail = aOutlook.CreateItem(olMailItem)
aEmail.Importance = olImportanceHigh
aEmail.Subject = "** Subject here **"
aEmail.Body = "**Message here**"
aEmail.Recipients.Add "joe.bloggs@hotmail.com"
aEmail.Attachments.Add "C:\Accounts\Filename.xls"
aEmail.Attachments.Add "C:\Accounts\Filename 2.xls"
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.