J
Joey Lichtenstein
I have had code to generate alert emails using VBA for years now, but all
of a sudden instead of the alert emails being sent out, they are now
getting stuck in my drafts folder. I have to manually go into the drafts
folder and hit send on each one, which is not what I want!
Any ideas what can cause this? What is really strange is sometimes they
send fine, then sometimes they get stuck.
I had been using the following code (with Outlook Redemption) for years
now without any problems:
Sub MailDoc2(SubjectLine As String, MessageBody As String, Email)
Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(olMailItem)
myItem.To = Email
myItem.Subject = SubjectLine
myItem.Body = MessageBody
Set myRedMsg = CreateObject("Redemption.SafeMailItem")
myRedMsg.Item = myItem
myRedMsg.Send
End Sub
Thanks very much in advance!
Joey
of a sudden instead of the alert emails being sent out, they are now
getting stuck in my drafts folder. I have to manually go into the drafts
folder and hit send on each one, which is not what I want!
Any ideas what can cause this? What is really strange is sometimes they
send fine, then sometimes they get stuck.
I had been using the following code (with Outlook Redemption) for years
now without any problems:
Sub MailDoc2(SubjectLine As String, MessageBody As String, Email)
Set myOlApp = CreateObject("Outlook.Application")
Set myItem = myOlApp.CreateItem(olMailItem)
myItem.To = Email
myItem.Subject = SubjectLine
myItem.Body = MessageBody
Set myRedMsg = CreateObject("Redemption.SafeMailItem")
myRedMsg.Item = myItem
myRedMsg.Send
End Sub
Thanks very much in advance!
Joey