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
  #1  
Old December 5th 06, 06:45 PM posted to microsoft.public.outlook.program_vba
Doug Glancy
external usenet poster
 
Posts: 7
Default Duplicating public folder items in personal folders

(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.

Sorry for being so long-winded.

Doug


  #2  
Old December 5th 06, 07:21 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Duplicating public folder items in personal folders

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.


  #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.



  #4  
Old December 5th 06, 08:35 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Duplicating public folder items in personal folders

Thanks for pointing out where to look for the error. I've been struggling with a bad eyeglass prescription for 6 weeks now as they try to make one adjustment after another.

You can't use Copy to copy an item unless you have permission to create new items in the same parent folder. THe alternative is to create an entirely new item in the desired target folder and duplicate the property values one by one.

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

Regarding the error, I listed it in the code where it occurs.


"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


"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.



  #5  
Old December 5th 06, 08:56 PM posted to microsoft.public.outlook.program_vba
Doug Glancy
external usenet poster
 
Posts: 7
Default Duplicating public folder items in personal folders

Thanks Sue,

My sympathies regarding your glasses.

I've got permissions in both folders, so I don't know if that's the problem.
I'll try what you suggested and see if that helps.

I find Outlooks object model even more confusing than Excel's - I think I
need to buy a book.

Doug

"Sue Mosher [MVP-Outlook]" wrote in message
...
Thanks for pointing out where to look for the error. I've been struggling
with a bad eyeglass prescription for 6 weeks now as they try to make one
adjustment after another.

You can't use Copy to copy an item unless you have permission to create new
items in the same parent folder. THe alternative is to create an entirely
new item in the desired target folder and duplicate the property values one
by one.

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

Regarding the error, I listed it in the code where it occurs.


"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


"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:22 AM.


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.