Reoccuring appointment issues when exporting Calendar to Excel

Status
Not open for further replies.

dip324

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
Hello,

At work we use our outlook calendars to track and analyze time. Several people (but not all) are having two issues with the export:

1. We have a reoccuring event called Work Hours which obviously displays how many hours people worked on that day. When the calendar is exported, there are extra Work Hours events for the weekend in Excel that are not indicated in the calendar (no one works weekends).

2. If the time of a reoccuring event is modified, that event will not export to excel.

Thank you for your help,

Sincerely,

Deanne
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Exceptions should export - unless the exception was erased. (Exceptions are easy reset.)

Is there any thing about the weekend events that export that might give us a clue? Is there something similar in the ones that include weekends and ones that don't?
 

dip324

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
The only pattern I can find is that it copies the Work Hours from Mon-Fri and carries it over to the weekend. On the reoccuring section of the event, Sat and Sun are not checked. No one has work hours for the weekend so they are never on there. I checked the 'Work Hours' Option in Outlook under File--> Options --> Work Time and only the work days are selected.

Deanne
 

dip324

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
The exceptions also are visible on the calendar (not erased), it's just they are not there when it's exported.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
e_a_g_l_e_p_i Outlook 2010 How can I change the font size on right side appointment pane Using Outlook 12
Chiba Create an appointment for all the members Outlook VBA and Custom Forms 1
D Prevent popup of "Do you want to save changes?" when closing after opening an appointment to view Outlook VBA and Custom Forms 2
O Calendar - appointment templates and categories Using Outlook 1
W Appointment userproperties disappear Outlook VBA and Custom Forms 4
Nessa Can't create new appointment Using Outlook 1
F Appointment Show All Fields Using Outlook 1
C Trying to populate an appointment ComboBox from Excel Outlook VBA and Custom Forms 2
A Possible to hide ribbon with custom appointment form? Outlook VBA and Custom Forms 3
W Appointment occurrences change the location property Using Outlook 0
W Space in an Outlook appointment body Using Outlook 0
Dave A Run macro on existing appointment when it changes Outlook VBA and Custom Forms 1
JoeG Appointment Delete/Change Recurrence Outlook VBA and Custom Forms 0
S Display PF contact folder items to select contact to link to appointment Outlook VBA and Custom Forms 1
M Forward Appointment as BCC with VBScript Outlook VBA and Custom Forms 7
K Update Appointment category when changed in Excel Using Outlook 3
S View Appointment in Text Wrap in Outlook 2007 Month Calendar View Using Outlook 0
A Day view - print appointment details Using Outlook 1
R Recover Deleted Appointment in Calendar Using Outlook 0
N Select Appointment subject line from combobox or list Outlook VBA and Custom Forms 1
S Appointment-Cannot set Categories because ConversationID is not set Outlook VBA and Custom Forms 1
D Record Appointment to Calendar on "Public Folder" Outlook VBA and Custom Forms 13
G Copy Contact field to Appointment Custom Form Field Outlook VBA and Custom Forms 2
G How to Copy Multi Select Listbox Data to Appointment Outlook VBA and Custom Forms 3
S Appointment colour categories disappear Using Outlook 4
G Using Data From Combo Box in Appointment Body Outlook VBA and Custom Forms 6
C Set reminder / appointment by right clicking email Using Outlook 1
A Add attachments to appointment based on field values Outlook VBA and Custom Forms 0
S how to set user properties to a newly created appointment Outlook VBA and Custom Forms 12
Y Creating custom appointment request form with multiple mail recipients Outlook VBA and Custom Forms 5
S my vbscript button1_click code works on appointment created but not on opening an existing apntmn Outlook VBA and Custom Forms 16
G Create an Appointment at the Contact's Address From Email Outlook VBA and Custom Forms 0
Diane Poremsky Create Task or Appointment and Insert Selected Text Using Outlook 0
Pierce007 Maps/location in making an appointment Using Outlook 2
A Get shared calendar name or id in custom appointment form Using Outlook 0
Diane Poremsky Create Appointment From Email Automatically Using Outlook 0
C Reminder for single-click appointment Using Outlook 2
P Appointment times are off by one minute Using Outlook 1
M receive mail when appointment category changes and create task from appointment Outlook VBA and Custom Forms 0
B VBA Code to create appointment from email Outlook VBA and Custom Forms 1
Diane Poremsky Create an Outlook appointment from an email message Using Outlook 4
Diane Poremsky Create an Appointment Diary Using Outlook 0
N Adding Appointment Item in Outlook to Shared Calendar Folder Outlook VBA and Custom Forms 7
Diane Poremsky Send an Email When You Add an Appointment to Your Calendar Using Outlook 0
J Outlook calendar...How to add an event or appointment without a border around it? Using Outlook 9
F Outlook 2010 Search Appointment Notes Using Outlook 0
D Calendar appointment, type 2 Using Outlook 2
Diane Poremsky Use VBA to get an Appointment's Time Zone Using Outlook 0
C Autofill subject line in appointment from options selected in combobox Using Outlook 6
J Create an appointment from Contact list with the Company name in the Subject line Using Outlook 1

Similar threads

Top