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
K Add an entry to a specific calendar Using Outlook 0
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 4
G Stop Outlook 365 adding meetings to calendar Using Outlook 2
Christopher M 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
C Outlook 2016 Unable to delete Gmail IMAP calendar Using Outlook 3
A force outlook to default to MY calendar Using Outlook 3
O Carriage Return - Line Feeds - exporting Calendar events Using Outlook 0
K How to share multiple calendar items Using Outlook 1
P Calendar Day View only shows 1 all day event Using Outlook 0
Hobbes Outlook 365 Calendar spreads into second calendar Using Outlook 3
J Macro to Insert a Calendar Outlook VBA and Custom Forms 8
C Tracking Calendar Changes? Using Outlook 1
O Batch update calendar Using Outlook 3
P Outlook calendar and contacts sync problem-outlook disconnects Using Outlook.com accounts in Outlook 2
HarvMan Toggle between calendar and email in Outlook 365 Using Outlook 12
e_a_g_l_e_p_i Is it possible to transfer things from one calendar to another Using Outlook 2
M Outlook calendar is missing Using Outlook 2
A Any way to make Outlook Calendar invitations look right to Gmail/Google Calendar users? Using Outlook 3
O Calendar - Location: what happens when using my own way of entering locations Using Outlook 1

Similar threads

Top