Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2019
    Thanked 0 Times in 0 Posts

    Creating Outlook Reminders in Multi-Tab Excel Spreadsheet

    QUA-04-10-03; Monthly Quality Report.xlsxI hope someone can help me. I am trying to set up email reminders for dates in an excel spreadsheet. I have previously seen a wonderful piece of work on this forum, dealing with a project reminder system. My question is, would it be possible to write a standard macro, which I can apply to each tab and select the data to use in the reminder? I have attached a sample of the spreadsheet for reference.

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Pa, USA
    Thanked 836 Times in 761 Posts
    Welcome to the forum. I see dates in your register sheets that you can time your reminders from but I don't see email address columns anywhere.

    For a reminder to work, unless you want to hardcode the fields, you will need subject, recipient, email address, and date columns as well as columns that contain data to build the body of the email.

    Please explain what you want to do using a couple of the tabs as an example.


Posting Permissions

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