Calendar Macros?

Status
Not open for further replies.

LostinSpace

Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
Hi folks,

I'm looking to basically create a set-up in outlook that, once I select the start date, populates my calendar based on the distance from that start date.

To be more concrete, I run programs. And while they differ from client to client, there are certain things that need to be done for all programs. So 60 days prior to the start of a program certain things needs to be done. Same goes for 30 days out, 20 days out, ect. I'm trying to find a way to say "Program X starts on July 1st" and have Outlook assign events to my calendar based on that information.

Any ideas? Am I making sense? All help is appreciated.

Thank you,

Lost
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Yes, you are making sense - but Outlook doesn't offer a really simple way to do it. You can create an appointment on the date and copy it, then change the date in the copy by typing 60 days before in the date field. Repeat as needed.

If you start on today and need dates going forward, you'd use 60d instead. The calculated dates are always based on the date originally in the date field, so its easy to go forward or backward from a date, but you will need to do it for each appointment in the series - you can't tell outlook to create an appointment on DateA, 30days later, 60days later etc.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
BTW, you could also create the appointments in Excel and import. This works well if you need to skip weekends and holidays in your calculations.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
D Outlook macros to create meeting on shared calendar Outlook VBA and Custom Forms 10
S Using Macros in the Outlook Calendar Using Outlook 2
Commodore Slow calendar Using Outlook 0
C How to import Outlook calendar? Using Outlook 0
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 2
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
I Outlook is stuck at "Updating Calendar" Using Outlook 1
AmonRa Outlook 365 calendar - too much white space Using Outlook 0
M Cannot read the calendar Using Outlook 9
Horsepower What is best calendar practice for iMac Using Outlook 3
M Calendar greyed out Using Outlook 0
M Unable to share 2019 calendar Using Outlook 0
Fozzie Bear Accepted Zoom Invites deleting without going into Default Calendar - Office 2016 Mac Using Outlook 3
P Outlook 2013 Calendar Archiving Using Outlook 0
Fozzie Bear Sharing Birthday Calendar Using Outlook.com accounts in Outlook 3
M Calendar daily Appointments and printing Using Outlook 0
I Google Calendar <calendar-notification@google.com> appearing as a duplicate entry Using Outlook 2
L Sharing Calendar for Only Scheduling Using Outlook 2
S Excel VBA and shared calendar issue Outlook VBA and Custom Forms 3
E Work uses live accounts for emails for all employees. Can we use the outlook calendar to give the employees an universal work schedule calendar? Using Outlook 1
J O365 - Adding Shared Google Calendar ICS link issue in O365 Using Outlook 0
B Outlook Calendar not coming down from cloud Using Outlook 2
J Time Zone Issues - Outlook Calendar and Webcal Feed Using Outlook 8
N Backing Up Exchange Calendar Using Outlook 13
N Having Shared Calendar shift to Current day Using Outlook 0
K UDF with formula not showing on Calendar custom view. Outlook VBA and Custom Forms 0

Similar threads

Top