Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Solved
Outlook only processes outgoing mail when openned
Posted on 2009-05-14
suddenly Outlook does not process outgoing mail created using VBA except when Outlook is opened on the desktop. The mail can be seen staged in the "Outbox" and will process instantly upon the program startup. I have included the snips that create the e-mail within the VBA code.
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim CurrFile As String
Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)
ActiveWorkbook.Save
CurrFile = ActiveWorkbook.Path & "\" & ActiveWorkbook.Name
With olMail
.To = "bgustafson@lincolnwayenergy.com;dzimmerman@lincolnwayenergy.com;single@lincolnwayenergy.com;srichardson@lincolnwayenergy.com;tharrison@lincolnwayenergy.com;vwalter@lincolnwayenergy.com"
.CC = "rsauer@hawkrenew.com;ehalverson@hawkrenew.com"
.Subject = "Distiller Grain Load and Contract update - Nevada"
.Body = ActiveSheet.Range("c3").Text & vbCrLf
'.Attachments.Add CurrFile
.Attachments.Add "s:\reports\nevada loads pub.xls"
.Display
.Send
End With
Set olMail = Nothing
Set olApp = Nothing
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
3 Comments
What version of Outlook are you using?
If you have just upgraded to a more recent version its likely the Security Update in Outlook has now stopped this from happening.
http://www.slipstick.com/outlook/esecup.htm
If you have just upgraded to a more recent version its likely the Security Update in Outlook has now stopped this from happening.
http://www.slipstick.com/outlook/esecup.htm
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article will help to fix the below error for MS Exchange server 2010
I. Out Of office not working
II. Certificate error "name on the security certificate is invalid or does not match the name of the site"
III. Make Internal URLs and External…
In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
- Microsoft Office
- Office 365
- Outlook
- Office / Productivity
- Microsoft Word
- Microsoft PowerPoint, Microsoft Excel, *Office 2013, *office 2010, *Office 2016
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Course of the Month5 days, 4 hours left to enroll
670 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.