Thread: [Solved] Have Excel automatically send an appointment to Outlook
View Single Post
 
Old 09-12-2011, 01:42 PM
paulw793 paulw793 is offline Windows XP Office 2007
Novice
  
Join Date: Sep 2011
Posts: 5
paulw793 is on a distinguished road
Default Have Excel automatically send an appointment to Outlook
I did a bit of googling before I found this forum, but still have yet to find an answer.

I've got a spreadsheet (huge) that has a list of dates in column F.

Is it possible to have Excel automatically put a date in Outlook's Calender 30 days from the date in column F(only > 01/01/11) with the subject of Column B, but only the rows with an "X" in column G?

Here is the link to the SS so you can get a better understanding:
https://docs.google.com/spreadsheet/...lzOUE&hl=en_US
Reply With Quote