nitey4ever
01-13-2015, 10:16 AM
I am on a bit of a time crunch as I have been laid off from my current position with 2 weeks notice. I am trying to set up something quickly to assist those that are left to do my work.
Based on the scripts at [Solved] Excel generate calendar appointments in Outlook, post #20 (sorry, newbie, can't post links), I was hoping someone may be able to help me out.
I do have experience with coding, but it is from almost 15 years ago now.
As with everyone who needs help, *I* think what I need is simple. Based on the data in this table (more rows in my worksheet, I'm just giving you the example):
Address
Possession
Warranty Ends
Name
Email Address
Reno Done
Last Contact Made
Next Contact Due
Notes
110 Lakeview
10/9/2014
10/8/2016
Joe Smith
email address
kitchen
na
1/7/2015
I would like to set up 6 all-day appointments in Outlook:
Possession Date (as above)
Possession Date + 90 days
Possession Date + 180 days
Possession Date + 365 days
Possession Date + 545 days
Possession Date + 730 days
The appointments only need the address as the Subject, a 3-week reminder (ReminderMinutesBeforeStart = 30240), and the Notes column as the Body.
Then it obviously needs to not create duplicate appointments.
If anyone could assist me with this (and getting it running properly) it would be greatly appreciated (and possibly worth a beer fund donation?)!
Based on the scripts at [Solved] Excel generate calendar appointments in Outlook, post #20 (sorry, newbie, can't post links), I was hoping someone may be able to help me out.
I do have experience with coding, but it is from almost 15 years ago now.
As with everyone who needs help, *I* think what I need is simple. Based on the data in this table (more rows in my worksheet, I'm just giving you the example):
Address
Possession
Warranty Ends
Name
Email Address
Reno Done
Last Contact Made
Next Contact Due
Notes
110 Lakeview
10/9/2014
10/8/2016
Joe Smith
email address
kitchen
na
1/7/2015
I would like to set up 6 all-day appointments in Outlook:
Possession Date (as above)
Possession Date + 90 days
Possession Date + 180 days
Possession Date + 365 days
Possession Date + 545 days
Possession Date + 730 days
The appointments only need the address as the Subject, a 3-week reminder (ReminderMinutesBeforeStart = 30240), and the Notes column as the Body.
Then it obviously needs to not create duplicate appointments.
If anyone could assist me with this (and getting it running properly) it would be greatly appreciated (and possibly worth a beer fund donation?)!