calendar to excel spreadsheet

Status
Not open for further replies.
D

davidelebrun

Member
Outlook version
Outlook 2010 32 bit
Email Account
POP3
I have a one page excel spreadsheet months as columns and days as rows for one year but I have to copy manually each of my daily entries from outlook = can this be automated ? David
 
I'm not sure what you mean by months as columns and days as rows, but as long as it's a standard table format with each entry in a row, you can either export to a csv then copy the rows (because export will replace the contents, not append) or use a macro (can append). This macro shows how to do it - Macro to Export Outlook Fields to Excel - it uses mail in the example but it can easily be changed to use appointments.
 
Status
Not open for further replies.
< How to show recipient email address? | Auto Insert of filename when selecting 'Remove Attachment' >
Similar threads
Thread starter Title Forum Replies Date
S Excel VBA and shared calendar issue Outlook VBA and Custom Forms 3
T Outlook Calendar 2016 import Excel Using Outlook 1
R Exporting Excel data to Outlook 2016 Calendar Outlook VBA and Custom Forms 20
P Selecting specific calendar from Excel Outlook VBA and Custom Forms 5
Denis Hi everyone!!! Need some help with Excel to Exchange Calendar??PLEASE>>> Using Outlook 1
J Importing to the correct calendar from Excel 2010 to Outlook 2010 Outlook VBA and Custom Forms 2
A Excel to Shared Outlook Calendar Using Outlook 1
T Importing Excel 2010 data into Outlook Calendar 2010 Using Outlook 12
D Reoccuring appointment issues when exporting Calendar to Excel Using Outlook 3
M outlook shared calendar data export to excel sheet Using Outlook 1
Forum Admin excel outlook exchange calendar Using Outlook 1
H add an appointment for a custom calendar, vba excel Outlook VBA and Custom Forms 2
P ics calendar entries suddenly open up new Outlook Using Outlook 3
G Forms error on iCloud calendar Using Outlook 17
V select default calendar Outlook VBA and Custom Forms 3
I Outlook 2024 LTSC syncing with iCloud calendar - can only make appt. in iCloud Using Outlook 2
I Cant delete an appointment in Calendar Using Outlook 2
S Missing categories in Outlook calendar Using Outlook 10
M Calendar items have a pale pink blushing Using Outlook 3
P Windows 11/Office 365 - can't forward calendar entry as ics file Using Outlook 3
O How to share calendar categories? Using Outlook 4
T Cannot delete a calendar Using Outlook 0
A OL24 Calendar folder pane too narrow Using Outlook 9
F Sync Outlook Calendar Using Outlook 0
F Show events in Monthly Calendar Using Outlook 3
E Subscribing to another calendar when each party uses Office 365 Family Using Outlook 3
M Retaining old contacts and calendar in new account setup Using Outlook 6
P Email and calendar entry text now shifts right about 3 tabs worth of space Using Outlook 1
N Best way to sync calendar and contacts between Outlook 365 and Outlook on iPhone Using Outlook 4
H Macro to Delete Duplicate items in Outlook calendar where title is the same and date is the same Outlook VBA and Custom Forms 0
J Emails with .ICS calendar invitations attached don't contents when received in Outlook 365 Using Outlook 6
O Any 3rd party tool that sync (mirror) from Outlook Calendar to Google Calendar? Using Outlook 5
Fozzie Bear Calendar Events created on iPhone have suddenly start sending invitations to attendees Using Outlook 2
J Set calendar default to 'none' (policy) Exchange Server Administration 3
J Calendar events created on iPhone automatically changing default alert from 'None' to 'Time of Event' Using Outlook.com accounts in Outlook 0
G Outlook 365 My iCloud Outlook doesn’t work after reinstalling Microsoft365 on Windows 10 PC – now I get error message on contacts and calendar Using Outlook 1
G Creating Macro to scrape emails from calendar invite body Outlook VBA and Custom Forms 6
U When opening shared Calendar "The set of folders cannot be opened" Using Outlook 0
P Can no longer sync Outlook with iPhone calendar after iPhone update to 17.1.1 Using Outlook 7
P turn off the default "all day" check box in new calendar items. How? Using Outlook 1
A Outlook 365 New Appointments All saved to a 365 default calendar on Mac Using Outlook 0
V Unchecking my calendar and leaving shared one visible Outlook VBA and Custom Forms 1
V VBA Categories unrelated to visible calendar and Visual appointment Categories Outlook VBA and Custom Forms 2
M New Calendar Appointments: Conditionally turn off reminder and show time as free Using Outlook 14
J Cannot edit a calendar event received as an invitation Using Outlook 2
H Outlook 365 O365 outlook calendar item editing Using Outlook 1
Kika Melo Outlook Calendar deleted appointments not in Deleted Items folder Using Outlook 3
P Copying ALL calendar entries from Calender in PST file to IMAP OST file? Using Outlook 1
e_a_g_l_e_p_i Question about calendar Using Outlook 5
icacream Outlook 2021 - Google calendar in the peek Using Outlook 0

Similar threads

Back
Top