 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Programming VBA / May 2004Outlook 2002 and 2003
I have an Access program that is creating appointments in Outlook 2002. Over the last week, two new PC's have been added to the network and have Outlook 2003. Are there any issues that I need to address to ensure that my code (see below) works for both Outlook 2002 and 2003? Dim outobj As Outlook.Application Dim outappt As Outlook.AppointmentItem Set outobj = CreateObject("outlook.application") Set outappt = outobj.CreateItem(olAppointmentItem) With outappt .Start = Me.txtTicklerDate + #9:00:00 AM# If Form_Contacts.CompanyName > " " And _ Form_Contacts.Institution = True Then .Subject = Form_Contacts.CompanyName Else .Subject = Form_Contacts.LastName & ", " & Form_Contacts.FirstName End If .Body = Me.txtTicklerText .Location = Form_Contacts.StoreDesc .ReminderMinutesBeforeStart = 10 .ReminderSet = True .Save End With ' Release the Outlook object variable. Set outobj = Nothing Set outappt = Nothing Thank you, Thomas J. Kroljic .Body and the Inspector properties used to get the email editor are restricted in Outlook 2003 and Outlook 2002 SP3. Only reading .Body, writing it is still OK. In a COM addin (or Outlook VBA project) those properties are trusted if you derive all Outlook objects from the Application object that is intrinsic to Outlook VBA or is passed in a COM addin's On_Connection event. See http://www.outlookcode.com/d/ol2003problems.htm for more information on what's new with Outlook 2003. Be aware that many of the same things apply to Outlook 2002 SP3 and will apply to Outlook 2000 SP4 when it is released.  SignatureKen Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm > I have an Access program that is creating appointments in Outlook 2002. Over > the last week, two new PC's have been added to the network and have Outlook [quoted text clipped - 28 lines] > Thank you, > Thomas J. Kroljic Ken, Thanks for the informative response. I'll definitely check out the link you sent. A couple of my users are telling me that it takes sometimes 30 seconds to 20 minutes before the appointments show up in their Outlook calender. Is there anyway to decrease this time lag? Do I, as a programmer, have any control over this communication between applications or exchange? Thanks, Thomas J. Kroljic > .Body and the Inspector properties used to get the email editor are > restricted in Outlook 2003 and Outlook 2002 SP3. Only reading .Body, writing [quoted text clipped - 41 lines] > > Thank you, > > Thomas J. Kroljic If the users are working with Outlook 2003 and cached Exchange mode it can take a while for changes to propagate. Not much you can do about that usually. You can do something if you are using Extended MAPI, see http://support.microsoft.com/default.aspx?id=834496 For other information about slow response using cached mode see http://support.microsoft.com/default.aspx?id=826755 SignatureKen Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm > Ken, > Thanks for the informative response. I'll definitely check out the link [quoted text clipped - 7 lines] > Thanks, > Thomas J. Kroljic Ken, Thanks for the info...I read the knowledgebase articles you included. Thanks, Thomas J. Kroljic > If the users are working with Outlook 2003 and cached Exchange mode it can > take a while for changes to propagate. Not much you can do about that [quoted text clipped - 19 lines] > > Thanks, > > Thomas J. Kroljic |
Reply to this Message |
 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
|
©2008 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.