link date in a cell with outlook reminders

so I am creating a workbook in excel....its for the farm . its my girlfriend's brainchild....first is add a picture to the background...figured that our by adding it as a header...have some minor photo editing to do to get it perfect but as I am in the creating stage that's a fine tuning thing that will come later......unless you know a way to make the pic stay put if you scroll the cells?....step 2 integrate the due date for when the animal should give birth to outlook calendar with a 1 week advance reminder...i have the basic math encoded to get the due date but i bet you can guess where i am hung up...integrating to outlook....and setting up the reminders/appointments...whatever....third step backwards integration IE from the calendar to excel...if its an isolated calendar specifically for the farm (this shouldn't bring up "family" birthdays and such into the excel cells).... currently there are 6 sheets in the excel workbook...if the backwards integration were to work we wouldn't want the cows added to the pigs sheet.....and next we want the cells to shift down so that new creatures are added to the top of the spreadsheet....

if you can help with any and or all of this please respond....not sure how this will tell me you responded because i signed in with Facebook so if nothing else my e-mail is redcoon1@gmail.com

Although this is very doable, seems like you are complicating things by throwing Outlook into the mix. Excel can monitor the dates, calculate date differences, and toss out a message box when a reminder is due. Short of sending an email, I don't think you need Outlook to do what you want.

outlook

Maud,

I am interested in just setting the reminders in Excel. Outlook's involvement was mostly due to a lack of knowledge of what excel can do. Also, my girlfriend likes that outlook calendar sync's with her phone, and she can add to her calendar from the phone. could somehow an sms message be pushed to the cell phone from Excel?

I have a similar question...I have an excel file with important construction deadlines and I would like to receive notifications either via email or through the calendar before these dates are due. How can I link the cells for the deadlines in the outlook, do I have to use macro?