I'm look for the most efficient way to send a file on your hardrive as an attachement via email.
The closes I've got so far is an Outlook macro
Dim olApp As Outlook.Application
Dim objMail As Outlook.MailItem
Set olApp = Outlook.Application
Set objMail = olApp.CreateItem(olMailItem)
objMail.BodyFormat = olFormatPlain
objMail.Subject = "Hi buddy"
objMail.Body = "Whats up" + Chr(13) + Chr(10) + "Greg"
objMail.To = "email@example.com"
I don't know how to schedule this macro to run Monday morn for example every monday.
Any help would be greatly appreciated (also if you know of another way to automatical email a file that would be helpful as well)