Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2015
    Posts
    3
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Excel -> Outlook Task Reminder

    Hi,

    I was trying to do some research around and try to edit the code on my own.
    But it seems like it ain't as easy as I thought

    I'm trying to create a service database in Excel that will generate task reminder in Outlook.

    Is it possible to generate a task reminder for both the date in "Column P" or "Column O" ?
    And how can I skip the blank cell?

    For those who is able to help, THANK YOU in advance
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Christine

    Welcome to the Lounge as a new poster!

    ..see attached sample file.

    I fixed some of the formulas, and amended the vba code.
    Please review the changes I made.

    I ran a quick test ran on my system, and reminders were set OK.

    zeddy
    Attached Files Attached Files

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

    christine85 (2015-09-30)

  4. #3
    New Lounger
    Join Date
    Sep 2015
    Posts
    3
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi Zeddy,
    Thank you!!!!!!!

    I just manage to run it with outlook. But it seems like it failed to skip the blank cell...
    I'll try my luck to fix it on weekend

  5. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Christine

    ..remind me about that blank cell again - which one are you referring to??

    zeddy

  6. #5
    New Lounger
    Join Date
    Sep 2015
    Posts
    3
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Hi Zeddy
    Possible to skip the blank cell for column P & Q?
    Or it is better for me to remove it to other spreadsheet ?

Posting Permissions

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