A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Outlook » Calendar
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Export Calendar loses label field?



 
 
Thread Tools Display Modes
  #1  
Old April 26th, 2004, 01:18 PM
NickW
external usenet poster
 
Posts: n/a
Default Export Calendar loses label field?

Hi All,

I have a need to export calendar items from a mailbox
calendar to csv, and then re-import (due to a timezone
screwup with DST changeover - see
http://support.microsoft.com/default.aspx?scid=kb;en-
us;290835).

The thing is, the export filed mapping to csv or Excel
file types loses the 'label' from each appointment. This
is rather important to us for a number of reasons.

Any ideas?

Also, if any of you have a better idea to deal with the
DST switchover problem that I have, that'd be more than
welcome. The problem is that a number of appointments
(approx 2000) were created on a client that is not set to
auto-adjust to DST (don't ask). When this DST shift
happened, those appointments skewed out by an hour. My
fix (until I lost the labels) was to export those
appointments, fix the client machine, and then re-import
them. Perhaps I could 1+ the appointment times using a
CDO script or similar - any other ideas / samples?

Cheers, thanks in advance

NickW
  #2  
Old August 5th, 2004, 02:49 PM
enikon
external usenet poster
 
Posts: n/a
Default Export Calendar loses label field?


Hi!
Did you ever find a way of exporting the labels? I am also trying to
figure this out (want to take the calendar (only) to my home computer
from work)
Thanks.

NickW wrote:
*Hi All,

I have a need to export calendar items from a mailbox
calendar to csv, and then re-import (due to a timezone
screwup with DST changeover - see
http://support.microsoft.com/default.aspx?scid=kb;en-
us;290835).

The thing is, the export filed mapping to csv or Excel
file types loses the 'label' from each appointment. This
is rather important to us for a number of reasons.

Any ideas?

Also, if any of you have a better idea to deal with the
DST switchover problem that I have, that'd be more than
welcome. The problem is that a number of appointments
(approx 2000) were created on a client that is not set to
auto-adjust to DST (don't ask). When this DST shift
happened, those appointments skewed out by an hour. My
fix (until I lost the labels) was to export those
appointments, fix the client machine, and then re-import
them. Perhaps I could 1+ the appointment times using a
CDO script or similar - any other ideas / samples?

Cheers, thanks in advance

NickW *




--
enikon
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message610453.html

  #3  
Old August 6th, 2004, 04:48 PM
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: n/a
Default Export Calendar loses label field?

Did you try exporting to a .pst file? (Or just copying the items to a .pst
file?)

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


"enikon" wrote in message
...

Hi!
Did you ever find a way of exporting the labels? I am also trying to
figure this out (want to take the calendar (only) to my home computer
from work)
Thanks.



 




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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:06 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.