Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Setting Up Reminders (Office 2003)

    Hi everyone,
    Am working with excel 2003 and have this file which lists all responses to be received with dates.
    Is it possible to have an automated popup or,to highlight a corresponsing cell with yes or no or better still a macro to send an
    email to a defined user to ensure timely follow-ups... say 3 days prior to expiry dates. Currently all I do is highlight same in a different colour but that is really not good enough..
    So look foward to some smarter options.

    Thanks, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Setting Up Reminders (Office 2003)

    How do you want to initiate this? Should the user click on a command button, or should it be done automatically each time the workbook is opened, or ...?
    If you were to send an e-mail, do you want to send it again the next time, or should each response be marked in some way when an e-mail has been sent?

  3. #3
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Setting Up Reminders (Office 2003)

    Hi Hans,
    Thank you for your prompt response. A command button to get all the "no" and with a marked stated that a final reminder have been send to the user on the date 3 days prior to the deadline will be idea.

    cheer, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Setting Up Reminders (Office 2003)

    You can use the attached workbook as starting point; adapt for your specific needs.
    The workbook contains a macro, so make sure that macro security is not set to High and that you enable macros.
    If you need to send a more elaborate e-mail, you'd need to automate Outlook. This is more work.

Posting Permissions

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