calendar to excel spreadsheet

Status
Not open for further replies.

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
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
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.
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
B Linking from Excel to public outlook 2010 calendar. Using Outlook 0
H add an appointment for a custom calendar, vba excel Outlook VBA and Custom Forms 2
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 2
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 5
J Cannot edit a calendar event received as an invitation Using Outlook 1
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
e_a_g_l_e_p_i MY Outlook 2021 changed the format of the shortcuts for mail, calendar etc. Using Outlook 10
Fozzie Bear Shared Calendar For Scheduled Tasks Using Outlook.com accounts in Outlook 3
K Add an entry to a specific calendar Using Outlook 1
F Add a category before "Send an Email When You Add an Appointment to Your Calendar" Outlook VBA and Custom Forms 0
L Synch Outlook 365 calendar with iPhone Using Outlook 0
C Recover calendar Using Outlook 0
R How to prevent corrupted Notes format in Calendar and Contacts Using Outlook 0
L Duplicate calendar entries in Outlook 365 Using Outlook 3
G Stop Outlook 365 adding meetings to calendar Using Outlook 1
CWM550 Outlook 365 HELP! Calendar Craziness! Using Outlook 5
J Event/Meeting in Outlook Does Not Align with SharePoint Calendar Using Outlook 5
Commodore Slow calendar Using Outlook 0
C How to import Outlook calendar? Using Outlook 1
G Add contacts birthday to calendar Using Outlook 4
e_a_g_l_e_p_i Outlook 2021 all appointments not showing in calendar Using Outlook 2
V iCloud calendar problems, Outlook shuts down immediately Using Outlook 2
KeithJB iCloud calendar sync only works one way! Using Outlook 3
V Backup Calendar, Contacts, Tasks in an POP3 data file Using Outlook 3
O Unable to make changes to an existing Calendar entry Using Outlook 11
J VBA for outlook to compare and sync between calendar Outlook VBA and Custom Forms 1
A Meeting organizer calendar intermittently drops meeting after delegate sends invite Using Outlook 0
A Meeting organizer calendar intermittently drops meeting after delegate sends invite Exchange Server Administration 0
T Outlook 2010 Cannot edit Calendar entries in OL 2010. Using Outlook 1
M On behalf of not showing on calendar for boss Using Outlook 1

Similar threads

Top