This is the macro that I use. You can also add CC, BCC, Body, etc. I then add a "button" to my toolbar that runs the macro when I click it.
Sub sendmsg()
Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(olMailItem)
Set myRecipient =...
I am trying to find a way to have outlook send an email at a fixed time each day. I already have a macro that I click that creates an email with an attachement, but I'd rather have it sent automatically. Any help would be greatly appreciated.
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.