Approved: Fortect
You may see an error indicating Outlook Runtime Error 287. It turns out there are several ways to fix this problem, so let’s talk about it now. Runtime error 287 occurs when Microsoft Outlook crashes or freezes while running, hence the name. This does not necessarily mean that the code was damaged in any way, but it does mean that it did not work for the entire life of the product. This type of error will show up on your end as an annoying notification if not dealt with and fixed.
I have a case where a certain user wants to be alerted when deliveries are added to an Access database. The easiest way I could hope for is to set up automatic email distribution through Outlook 2010. Next password: have:
Dim oApp as Outlook.ApplicationDim oMail as mail item VarDnoteRef2weak as a chainDim varuser as stringvaruser = DLookup ("[Employee_Name]", "Employees", "[Employee_ID] =" & TempVars! gloggedin)varDnoteRef2 = DLast ("Supplier_Dnote_Ref", "Supplier_Dnotes")Set oApp to CreateObject ("Outlook.application")Set oMail = oApp.CreateItem (olMailItem)oMail.Body equals “A delivery receipt has been added tospecific database using "Varuser & & width in inches by" & Now () & ". "& _ vbNewLine & "Shipping slip:" & varDnoteRef2oMail.Subject is equivalent to "Automatic Delivery Notification: Notification"oMail.To = "[email protected]"to send a letterSetting up oMail means nothingoApp = define nothing
This code will work correctly if the person redeeming their code has opened Outlook. However, if the user has not started Outlook, the man or woman receives an error at the oMail.send
line.
Error # 287: Web Application Error 0 or Object Error.
What they get is a small icon on the laptop, which is an Outlook icon with a single cog / cog message that says another program may be using Outlook
. This is what I expect. But why doesn’t it work when sending?
How can I almost get this error / is there a solution?
Change (Update)
What’s even weirder is that I’m using F8 to iterate through the code. IT IS WORKING !!But still, if not, I call the number from deform properties, e.g. button_on_click
9.802
requested March 31, 2016 at 8:30 am.
Approved: Fortect
Fortect is the world's most popular and effective PC repair tool. It is trusted by millions of people to keep their systems running fast, smooth, and error-free. With its simple user interface and powerful scanning engine, Fortect quickly finds and fixes a broad range of Windows problems - from system instability and security issues to memory management and performance bottlenecks.
1,482
Not The Formula You Are Looking For? Check Out The Other Vba Ms-access Outlook-2010 Questions Described Or Ask Your Own Question.
Well, this is something I haven’t encountered before, but I found a solution.
The error message itself got me wondering why the submit command was not recognizing a particular application. Anyway, I asked if the code is fast. (I usually know where I got it fromthis tube hour, but I solved a common problem).
I just added a loop to delay the reliability of the pre-dispatch. I did this because access is not going to application.wait
.
Dim T1 as an optionDim T2 as an optionT1 = now ()T2 = DateAdd ("s", 1, T1)Make-up up to T2 <= T1 T1 = now ()ribbonto send a letter
This process doesn't happen very often, maybe 5 times maximum on another day, so I don't feel any discomfort when a one second delay causes real-time problems.
answered Apr 1, 2016 at 10:59 am
1482
Speed up your computer's performance now with this simple download.