Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / September 2007

Tip: Looking for answers? Try searching our database.

Access 2000 Outlook 2007

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bh - 17 Sep 2007 17:30 GMT
I'm trying to email from Access 2000 using the following:

   Dim objOutlook As Outlook.Application
   Dim objOutlookMsg As Outlook.MailItem
   Dim objOutlookRecip As Outlook.Recipient
   Dim objOutlookAttach As Outlook.Attachment

   Set objOutlook = CreateObject("Outlook.Application")
   Set objOutlookMsg = objOutlook.CreateItem(olMailItem)

   With objOutlookMsg
           Set objOutlookRecip = .Recipients.Add("Email addresses separated
by semicolons")
           objOutlookRecip.Type = olTo
           .Subject = "Whatever subject"
           .Body = "Whatever message text"
          For Each objOutlookRecip In .Recipients
              objOutlookRecip.Resolve
          Next
          .Display
   End With

   Set objOutlook = Nothing
   SendMessage = True

This process always worked fine with Outlook 2000 and then Outlook 2003;
however, in Outlook 2007, I get an Error 287 (Object definition error).  I
was using Outlook Library 11.0, previously, but now some users are using
Outlook 2007 instead of '03.  When I put the program on a machine with 2007,
however, the Library 12.0 is showing as referenced in my code-behind
(appearing to have grabbed automatically)...  The machine I actually
developed the app on has Outlook 2003, and only some of the users will have
2007, and I manually had chosen the 11.0 library.  Any ideas on how to
resolve this would be helpful.
Arvin Meyer [MVP] - 17 Sep 2007 21:46 GMT
Your code looks OK and shouldn't need anything more than the new reference
unless there is a problem with permissions. Try the code on my website:

http://www.datastrat.com/Code/OutlookEmail.txt
Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> I'm trying to email from Access 2000 using the following:
>
[quoted text clipped - 30 lines]
> have 2007, and I manually had chosen the 11.0 library.  Any ideas on how
> to resolve this would be helpful.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.