> Time Error
> Outlook 2010 Run Time Error 287
Outlook 2010 Run Time Error 287
It is odd that the email gets created properly. Probably something in the settings that I'm just not seeing? This is one of the things that it would try to stop. Where should a galactic capital be? http://opinfos.com/time-error/ms-excel-2010-run-time-error-1004.html
As others suggest error handling is required but doesnt solve the problem.... share|improve this answer edited Dec 3 '14 at 18:14 answered Dec 3 '14 at 18:07 Matt 23.6k72139 thanks Matt, I think you are correct. The macro will be still looking for outlook object library 15 instead of 14 which is unavailable in the latter machine. Red Flag This Post Please let us know here why this post is inappropriate.
Error 287 Application-defined Or Object-defined Error
I don't understand why the .send statement fails though. Same result. Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. Regarding the code from Andrewssd3: I tried the code as provided and i get a compile error on the first statement Dim oApp as Outlook.Application.
Advertisements Latest Threads BT tops UK broadband complaints list Becky posted Dec 20, 2016 at 3:44 PM 999 What is your emergency? Join the community of 500,000 technology professionals and ask your questions. I don't understand why the .send statement fails though. Excel Vba Runtime Error 287 Thanks for your help. 0 LVL 17 Overall: Level 17 Outlook 5 Message Active 3 days ago Expert Comment by:Maen Abu-Tabanjeh ID: 372593892011-12-08 why you don't thinking about VBscript used
I don't understand why the .send statement fails though. andrewssd3, IT WORKS!!!! sevenforums.com/tutorials/… –dee Dec 1 '14 at 19:37 I agree with Christmas007, define the variables as he mentions, ensure the cell "oftLocation" is correct in terms of content and format https://social.msdn.microsoft.com/Forums/office/en-US/ecce7b2a-8e4c-4e2e-b2e4-ad95f006d808/runtime-error-287-applicationdefined-or-objectdefined-error?forum=accessdev Just to get through a notification run I am changing .send to .display, but I hope there is a better solution
Run Time Error 287 Excel
I have tried several different methods of sending this email but the jist of it is ... Dim oLook As Object Dim oMail As Object Set oLook = CreateObject("Outlook.Application") Set oMail http://www.access-programmers.co.uk/forums/showthread.php?t=236012 Below is the code with the error handler. Error 287 Application-defined Or Object-defined Error Just to get through a notification run I am changing .send to .display, but I hope there is a better solution
You could try set Allow Programmatic Access in Outlook to 'always' or 'yes'. (not best practice, but it would at least let us verify whether this is the issue) RE: Sending have a peek at these guys Same result. My specs: Windows 7 64bit Visual Basic 6 / Visual Studios 6 I have referenced the Microsoft Outlook 14.0 Object Library (msoutl.olb) Here's my function code CODEPublic Function SENDOUTLOOKEMAIL(ByVal OUTEMLIST As Page [ ] Basic Outlook Outlook Form Design Outlook Expert Techniques Outlook and .NET Code Essentials 10 per page 15 per page 25 per page 50 per page Printer Runtime Error '287' Application-defined Or Object-defined Error
I'm leaning more toward some obscure outlook setting that I'm not familiar with... ------------------------------------ Over 20 years of programming, and still learning every day! button_on_click vba ms-access access-vba outlook-2010 share|improve this question edited May 18 at 9:02 asked Mar 31 at 8:30 LiamH 1,1961628 If you have a SMTP server (not only an this certainly helped me relearn a topic I forgot about. http://opinfos.com/time-error/ms-access-2010-run-time-error-2501.html Please > show me how to fix it.
Linked 0 Access add new line to table 1 Send mail through Outlook - Error 287 0 Can't figure out what object is being declared that is not SET Related 2Disable I added the code and ran a test. There is interaction with antivirus and the Trust Center will provide some information as well.
LiamH, May 11, 2016 #7 Ryan Miller Joined: Aug 23, 2016 Likes Received: 0 Assuming you are using the VBA from the Outlook application you want a handle on...
It is odd that the email gets created properly. But why does it fail on the send? Same result. Have you resolved your issue?
Leach (Access MVP) UtterAccess Wiki: (Articles, Functions, Classes, VB7 API Declarations and more) Dymeng: blog | Services Edited by Jack D LeachMVP Saturday, December 28, 2013 3:04 PM changed error number I will try in on my server and let you know how it works. 0 LVL 17 Overall: Level 17 MS Excel 16 Programming 2 Outlook 1 Message Expert Comment The IT guys have backed out all of the updates that have a "removing" option and the jobs still fail. http://opinfos.com/time-error/outlook-2010-runtime-error-91.html Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.
Specify a start-up form through options: Specify an Autoexec macro: Us… MS Access Advertise Here 720 members asked questions and received personalized solutions in the past 7 days. The only difference I found was in the Dim for oMail. Thank you, "Daniel Pineault" wrote: > Take a look at > > http://www.devhut.net/index.php?lang=en&pid=0000000013#OutlookAuto > > For a full Outlook automation function example which you can either simply > use or use Thank you. ------ strDocName = "frmStud" DoCmd.openfORM strDocName, acPreview, , "studId='" & glbStudId & "'" FileName = strDocName & ".pdf" DoCmd.OutputTo acOutputForm, strDocName, acFormatPDF, "C:\Temp\StudentForms\" & FileName, False â€˜========================================== 'Using Outlook
Set objOutlookRecip = .Recipients.Add("[email protected]") objOutlookRecip.Type = olCC ' Set the Subject, Body, and Importance of the message. .Subject = "Test Report" .Body = "Here are the reports" & vbCrLf & vbCrLf PC Review Home Newsgroups > Microsoft Access > Microsoft Access VBA Modules > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles I did try .display rather than .send. I did try .display rather than .send.
Settings there will be disabled if you are not running Outlook with administrator rights. How to block Hot Network Questions in the sidebar of Stack Exchange network? Just to get through a notification run I am changing .send to .display, but I hope there is a better solution
All was fine when we were using XP and 2003 but having upgraded to Win 7 and Office 2010 this no longer works. Mine is Dim oMail As Outlook.MailItem.