A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Tags: , , , , , ,

Restricting appointments in a user's calendar folder using RDO





 
 
Thread Tools Display Modes
  #1  
Old March 7th 07, 04:22 PM posted to microsoft.public.outlook.program_vba
nikolaj.sheller@gmail.com
external usenet poster
 
Posts: 1
Default Restricting appointments in a user's calendar folder using RDO

Hello

My assignment is as follows:
-I need to retrieve user appointments in a given timespan from
Exchange. Due to performance issues I need to be able to restrict the
folders containing appointments server side.

-I currently log on to Exchange using RDOSession, under an account
created specially for this purpose.

My question is:
-How can I restrict the appointments in a given user's calendar folder
using RDO?

My experiences a
-RDOFolders can't be restricted.
-MAPITables can be restricted, but can't (to my knowledge) be
converted into RDOFolders or RDOAppointmentItems again.
-RDOSearchFolders can contain RDOFolders that are restricted. I can
restrict my own calendar, but not other user's. I can only get a
search folder to access the current user's SharedDefaultFolder, i.e.
the following fails:
"rdoSession.GetSharedDefaultFolder(addressEntr y,
rdoDefaultFolders.olFolderCalendar);"
when using "RDOSearchFolder.Start()" on the search folder; although it
works for the special account.

I would appreciate any input regarding this problem.

Thank you
-Nikolaj

Ads
  #2  
Old March 7th 07, 04:50 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 3,778
Default Restricting appointments in a user's calendar folder using RDO

I use MAPITables for something like that. A restricted MAPITable can have
columns for the EntryID and StoreID of each item so you can retrieve the
individual items if needed, but if you include all the data you need as
columns in the table rows you usually don't even have to do that unless you
need to do something like read a stream that is too big to be retrieved as a
column or if you need to get data from collections like Recipients or
Attachments.

--
Ken 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


wrote in message
oups.com...
Hello

My assignment is as follows:
-I need to retrieve user appointments in a given timespan from
Exchange. Due to performance issues I need to be able to restrict the
folders containing appointments server side.

-I currently log on to Exchange using RDOSession, under an account
created specially for this purpose.

My question is:
-How can I restrict the appointments in a given user's calendar folder
using RDO?

My experiences a
-RDOFolders can't be restricted.
-MAPITables can be restricted, but can't (to my knowledge) be
converted into RDOFolders or RDOAppointmentItems again.
-RDOSearchFolders can contain RDOFolders that are restricted. I can
restrict my own calendar, but not other user's. I can only get a
search folder to access the current user's SharedDefaultFolder, i.e.
the following fails:
"rdoSession.GetSharedDefaultFolder(addressEntr y,
rdoDefaultFolders.olFolderCalendar);"
when using "RDOSearchFolder.Start()" on the search folder; although it
works for the special account.

I would appreciate any input regarding this problem.

Thank you
-Nikolaj


  #3  
Old March 7th 07, 09:46 PM posted to microsoft.public.outlook.program_vba
Dmitry Streblechenko
external usenet poster
 
Posts: 1,592
Default Restricting appointments in a user's calendar folder using RDO

Contact me at my private e-mail address for a beta version that adds
RDOFolder.GetActivitiesForTimeRange() method - it will return both simgle
instance appointments and expanded instances of recurring appointments.
MAPITable object can be restricted using the MAPITable.Restrict method.
New version of Redemption will also add MAPITable.ExecSQL method that allows
to retrieve the data in a standard ADODB.Recordset object by specifying a
regular SQL expression.

Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool

wrote in message
oups.com...
Hello

My assignment is as follows:
-I need to retrieve user appointments in a given timespan from
Exchange. Due to performance issues I need to be able to restrict the
folders containing appointments server side.

-I currently log on to Exchange using RDOSession, under an account
created specially for this purpose.

My question is:
-How can I restrict the appointments in a given user's calendar folder
using RDO?

My experiences a
-RDOFolders can't be restricted.
-MAPITables can be restricted, but can't (to my knowledge) be
converted into RDOFolders or RDOAppointmentItems again.
-RDOSearchFolders can contain RDOFolders that are restricted. I can
restrict my own calendar, but not other user's. I can only get a
search folder to access the current user's SharedDefaultFolder, i.e.
the following fails:
"rdoSession.GetSharedDefaultFolder(addressEntr y,
rdoDefaultFolders.olFolderCalendar);"
when using "RDOSearchFolder.Start()" on the search folder; although it
works for the special account.

I would appreciate any input regarding this problem.

Thank you
-Nikolaj



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
FormsDescription without RDO? Peter Marchert Outlook and VBA 13 February 21st 07 08:22 AM
Outlook 2003- Other user's folder... Vince$ Outlook - Installation 2 February 2nd 07 02:25 PM
Restricting who can modify a calendar dmp Outlook - Calandaring 1 October 18th 06 07:34 AM
Forwarding a copy of a form from a Public Folder to a user's inbox Bubba Smith Outlook - Using Forms 5 October 10th 06 04:57 PM
Configuring user's calendar appointments as tentative. ejptccs123 Outlook - Calandaring 1 August 22nd 06 07:46 PM


All times are GMT +1. The time now is 05:19 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2008 Outlook Banter, part of the NewsgroupBanter project.
The comments are property of their posters.
Adverse Credit Remortgage - Dirty Dozen Brass Band - Watch One Piece - Servidores - Secured Loans