Calendar Items - Copying enmasse to another folder via VBA

  • Thread starter Thread starter Alan
  • Start date Start date
Glad to hear you're making progress!

There is no such thing as a "PST clipboard," however. Maybe you could
explain exactly where this Exchange folder is located -- your mailbox,
someone else's mailbox, Public Folders -- along with your Outlook version
and whether you're accessing Exchange online or offline.
 
Sue Mosher said:
Glad to hear you're making progress!
Click to expand...

Me too!
There is no such thing as a "PST clipboard," however. Maybe you
could explain exactly where this Exchange folder is located -- your
mailbox,
someone else's mailbox, Public Folders -- along with your Outlook
version and whether you're accessing Exchange online or offline.
Click to expand...

Hi Sue,

The exchange folder is located within my personal mailbox on the
exchange server (not in someone else's and not within a public
folder).

I am running Outlook 2000 SP-3 (9.0.0.6627) in C/W mode with Security
Update.

My PC is running Win 2000 Pro SP-4 (5.00.2195)

I have all updates (per Windows Update and Office Update) installed
including critical, general, and driver updates.

The exchange server is Exchange 2000.


I am accessing exchange online.

HTH,

Alan.
 
Sue Mosher said:
What kind of compile error did you get? That's a perfectly
legitimate use of Move.
Click to expand...

The error message appears as soon as I try typing in the line (as
shown).

It reads:

Compile Error
Expected: end of statement
The other error you got means just what it says: Outlook items have
no Text property.
Click to expand...

Apologies - totally my mistake, I re-tried with the following code:


For Each ObjItem In AlanExchangeCalendarItems

Set ObjCopy = ObjItem.Copy

ObjCopy.Body = ObjCopy.Body & "Test text appended"

ObjCopy.Save

Set ObjCopy = Nothing

Next


This works, creating a copy of each item, with that text added.

Actually, it recursively creates a new item, adds the text, then
recognises that there is a new item to copy, so creates a new item,
..... and so on.

I had about 200 copies by the time my brain caught up and luckily
before my PC crashed (now deleted so no harm done)!

However, it worked so I can definately make a change to the property
of an item
in my exchange calendar folder from VBA.


Alan.
 
Re: Calendar Items - Copying enmasse to another folder via VBA
(19 April 2004 - 13:03am):


{Bump}
 
Back
Top