Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Aug 2014
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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

    thanks again

    Sam

    She likes the way it looksso now the hard work commences!

    here is a dropbox link to the workbook as it sits now

    https://www.dropbox.com/s/rhnupfyyv5...ial%20run.xlsx

    you will need to download the file to see it in its splendor...

  2. #2
    New Lounger
    Join Date
    Aug 2014
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Additional

    if i were to share this with other farmers, how would i get it to automacally open in "landscape" layout?

  3. #3
    New Lounger
    Join Date
    Aug 2014
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    obvious oversight in my needs...

    when the reminder is made in excel it needs to say something like xx doe Cell "A1 or A2 or....whichever one corresponds to the date) is going to give birth on "date"



    Thanks

  4. #4
    Bronze Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,200
    Thanks
    46
    Thanked 228 Times in 211 Posts
    Red Coon,

    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.

    Maud

  5. #5
    New Lounger
    Join Date
    Aug 2014
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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?


    Thanks,

    Sam

  6. #6
    Bronze Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,200
    Thanks
    46
    Thanked 228 Times in 211 Posts
    It could easily send an email instead to her and/or anyone else involved. Not sure about a SMS though.

  7. #7
    Bronze Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,200
    Thanks
    46
    Thanked 228 Times in 211 Posts
    Red Coon,

    Did some research. Apparently, sending an SMS is like sending an email. Phone carriers provide an address to convert emails to text messages:

    T-Mobile: phonenumber@tmomail.net
    Virgin Mobile: phonenumber@vmobl.com
    Cingular: phonenumber@cingularme.com
    Sprint: phonenumber@messaging.sprintpcs.com
    Verizon: phonenumber@vtext.com
    Nextel: phonenumber@messaging.nextel.com
    AT&T: phonenumber@mobile.att.net

    Below is a listing from a different source:

    sms.3rivers.net 3 River Wireless
    mobile.mycingular.com Cingular
    messaging.nextel.com Nextel
    tmomail.net T-Mobile
    vtext.com Verizon
    paging.acswireless.com ACS Wireles
    message.alltel.com Alltel
    message.alltel.com Alltel PCS
    alphanow.net AlphNow
    paging.acswireless.com Ameritech
    mobile.att.net AT& T PCS
    text.bell.ca Bell Canada
    wireless.bellsouth.com Bell South
    bellsouth.cl Bellsouth
    myboostmobile.com Boost
    mobile.celloneusa.com CellularOne
    sms.edgewireless.com Edge Wireless
    mymetropcs.com Metro PCS
    qwestmp.com Qwest
    messaging.sprintpcs.com Sprint PCS

  8. #8
    Bronze Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,200
    Thanks
    46
    Thanked 228 Times in 211 Posts
    Correction on the AT&T
    phonenumber@txt.att.net

  9. #9
    New Lounger
    Join Date
    Aug 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    good morning,

    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?

    thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •