Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    New Lounger
    Join Date
    May 2016
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Excel Linking to Outlook Calendar

    so this is my first post, ive been looking through a few similar ones however i cannot get what has already been done to adapt into mine so looking for some assistance


    What im looking to do is create outlook reminders based on information in the attached spreadsheet.

    Basically i want it set to whoever is using the spreadsheet on a shared drive and set to the date that the review is set for.

    The reminder would need to include the "Claim reference number" "Vehicle Reg" and any "notes" in the spreadsheet.

    Is this possible?

    its been a long time since ive done anything in excel

    Thanks in advance


    Copy of Fatality Spreadsheet.xlsm

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi Kieran

    Welcome to the Lounge as a new poster.

    Thanks for the sample file, it makes life easier.

    Basically i want it set to whoever is using the spreadsheet on a shared drive and set to the date that the review is set for.
    I'm not quite clear on what you are asking for here.
    Is this workbook a shared workbook on a shared drive??
    If Tom is using this file, will Tom be the person in column [G] ??
    If Fred is using this file, will Fred be the person in column [G] ??
    ..or, is it just that whoever is logged in and has the file open, you want that person's Calendar to be updated with all of the Review Dates that are coming up (from column [I] ) ??

    zeddy

  3. The Following User Says Thank You to zeddy For This Useful Post:

    kieran233 (2016-05-19)

  4. #3
    New Lounger
    Join Date
    May 2016
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi Zeddy,

    Thanks for your response,

    thsi workbook is for on a shared drive,

    basically if for example Tom entered the sheet, and added a new entry, i want him to be able to click a button and for it to set him a reminder for that specific entry based on the review date. does that make sense?

  5. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi Kieran

    ..ok, that makes sense.
    Let me look at it again.

    zeddy

  6. #5
    New Lounger
    Join Date
    May 2016
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks Zeddy

    appreciate any assistance

  7. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi Kieran

    Now back in action in Newcastle again!
    (Egypt - twice.)

    I've got your file working.
    Will post a file tomorrow.

  8. #7
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi Kieran

    See attached demo file.
    I have not put all the proper checks in place, e.g. if Outlook is not available on the User's computer etc etc.
    But, in the attached file, if you enter a date in column [I]-Review Date, a Task reminder will be set up for you.
    It requires that the Claim Number and Vehicle Reg mustn't be empty.
    The code used will check if a Task reminder has already been set for that Date and Claim.

    It will be quicker to work if your Outlook is already running (but it doesn't require it).

    ..have a test and let me know if this does what you want.

    zeddy
    Attached Files Attached Files

  9. #8
    New Lounger
    Join Date
    May 2016
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi zeddy, thanks will give it a test when I'm back at work Friday. But appreciate all your help

  10. #9
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Next Friday?????

    ..is it a Bank Holiday week or something.

    zeddy

  11. #10
    New Lounger
    Join Date
    May 2016
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts
    If only lol. Had to use my annual leave lol

  12. #11
    New Lounger
    Join Date
    May 2016
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatically Send Calendar Reminder based on condition from Excel

    Hi there, my problem is similar to yours, but I would like to be able to send reminders to our advisors in our college on their outlook calendar based from the date on the Excel file that we have for example, at least 7 days before the deadline of sending follow up letter to students. The system should automatically mark a reminder on an advisor calendar on Outlook that it's 7 days prior to him making a follow up with student. I haven't been coding for years so this is very challenging for me. Thank you for your help in advance.

  13. #12
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi orielle

    Welcome to the Lounge as a new Poster.
    It would be easier if you started your request as a new thread, and perhaps attach a sample file (with dummy data, but similar layout etc ).

    zeddy

  14. #13
    New Lounger
    Join Date
    May 2016
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Red face

    Thanks Zeddy. I will do that.

  15. #14
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,822
    Thanks
    134
    Thanked 481 Times in 458 Posts
    Hi orielle

    Great. That will make it easier for us to help you.

    zeddy

  16. #15
    New Lounger
    Join Date
    May 2016
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Zeddy, seems to work great, thank you very much for this

Page 1 of 2 12 LastLast

Posting Permissions

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