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

Duplicating public folder items in personal folders



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3  
Old December 5th 06, 07:54 PM posted to microsoft.public.outlook.program_vba
Doug Glancy
external usenet poster
 
Posts: 7
Default Duplicating public folder items in personal folders

Sue,

Thanks, I've looked at your site before and I think I looked at this
example, but will do so again.

Regarding the error, I listed it in the code where it occurs. I find that
when I'm responding to posts, it's always prudent to read them through
carefully, especially if I'm going to *advise* them on posting protocol ; ).

Regards,

Doug

"Sue Mosher [MVP-Outlook]" wrote in message
...
Yes, it's possible, but not a simple application by any means. Tom Howe's
Enterprise Calendar sample would be a good starting point; see
http://www.slipstick.com/calendar/scheduleall.htm

Whenever you're writing about an error, you ought to at least do your
readers the courtesy of explaining *what* error you get.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Doug Glancy" wrote in message
...
(I've never cross-posted before, but I'm new to the Outlook newsgroups,
and
thought I might get a more complete answer in this group than to my post
to
another yesterday)

At my office we are in need of a system to remind individuals of upcoming
deadlines. We want to centralize the input of the deadlines and to be
able
to set reminders on different deadliines for different individuals.

We are using Exchange 2003, Outlook 2003 and we use Cached Exchange mode.

Through googling various options, it seems like it's possible to create a
system with these features.

- One public calendar with all the deadlines
- Personal copies of the calendar on multiple individuals' computers
- copying, modifying or deleting items from the public calendar to
individuals' based on events in the public folder
- reminders set based on whether the individuals username is a checked
category

I'd be interested in opinions on whether this is workable, and if so, if
there are any examples of the code needed.

If this is workable, I have a specific problem (first of many, I'm sure).
I
wrote ApplicationStartup code to set the items in the public calendar so I
could capture the its events and that's working. I then wrote some simple
Item_Add event code to copy the added event to my personal calendar. It
works if I set a breakpoint and step through. When run without a
breakpoint, the item is copied but then I get an error. My wild guess is
there is some problem with lag time or cached Exchange mode. I also
thought
maybe the fact that the code first adds another copy to the public folder
was the problem, but I can't tell. In Excel VBA I would try turning off
events, but I can't find a way to code that in Outlook.

Here's the code:

Private Sub myOlItems_ItemAdd(ByVal Item As Object)
Dim calendar_item As AppointmentItem
' on next line I get the message
' "Method copy of object AppointmentItem Failed
Set calendar_item = Item.Copy
calendar_item.Move
Application.GetNamespace("MAPI").GetDefaultFolder( olFolderCalendar).Folders("schedule
- Doug's test")
Set calendar_item = Nothing
End Sub

Again, the code works, it actually copies the added item from the Public
folder to mine, but then I get the error and message, which makes me think
that it's the 2nd time through. But if I set a breakpoint beforehand, it
only goes through once.



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
How do I sync a calender in public folders w/ a personal calendar gopmommy Outlook - Calandaring 0 November 2nd 06 03:04 PM
Can I synchronize my personal calendar with a public folder calend Charliehd Outlook - Calandaring 1 July 26th 06 02:52 PM
items not appearing in public folder. [email protected] Outlook - Calandaring 0 July 5th 06 06:26 PM
Synchronising public folder to personal folders Richard Edwards Outlook - General Queries 5 March 20th 06 02:02 PM
Show number of unread items box gray out in Public Folders Selee Outlook - General Queries 1 March 9th 06 09:58 PM


All times are GMT +1. The time now is 11:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.