Closed Thread
Results 1 to 3 of 3

How do I write a macro or formula to send multiple outlook appointments/reminders

  1. #1
    Registered User
    Join Date
    12-20-2021
    Location
    Orkney, Scotland
    MS-Off Ver
    2016
    Posts
    7

    Question How do I write a macro or formula to send multiple outlook appointments/reminders

    I've attached the spreadsheet (Office 2016) I use to track the due dates of apprentice reviews. When a date is entered in column H, columns K - Z populate with dates. row 6 shows the date reviews are actually due, and row 7 shows the window within which the review must be carried out. I have it set up so that when today's date falls within the review window (row 7), a formula prompts me to click in the data row (the attachment shows this in row 15). Clicking the prompt, produces a prepopulated email ready to send to the named assessor (email address) who will appear in column G. There will be various assessors named in column G.

    I would like to add a formula/macro that will send calendar appointments to the email address in column G at the time when I populate the start date (Column H). I would like to send 8 appointments for the dates in row 7, columns K, M, O, Q, S, U, W and Y. I would want to repeat the process for each start date I enter, as I move down the spreadsheet. I just want to put dates in someone else's calendar (column G) as a first reminder of when reviews will be due. The automated email, will then give a second reminder when the review window opens.

    I have found possible solution to this online, but I'm not knowledgeable enough to edit macros to suit my own spreadsheet. I'd really appreciate some help on this please.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-20-2021
    Location
    Orkney, Scotland
    MS-Off Ver
    2016
    Posts
    7

    Re: How do I write a macro or formula to send multiple outlook appointments/reminders

    Please accept my apologies for posting this question twice. Just as I posted the first thread, my cat decided to intervene and subsequently posted it for a second time.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,540

    Re: How do I write a macro or formula to send multiple outlook appointments/reminders

    There were 12 minutes between the first and second threads - did you and your cat disappear into some sort of time warp???

    Please continue here: https://www.excelforum.com/excel-pro...reminders.html

    Happy Christmas!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How do I write a macro or formula to send multiple outlook appointments/reminders
    By Mr Wilks in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-22-2021, 07:57 PM
  2. Add multiple reminders to outlook calendar using VBA
    By ShakJames in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2017, 06:00 AM
  3. send reminders to outlook
    By plongberry in forum Excel General
    Replies: 1
    Last Post: 03-20-2015, 12:53 PM
  4. Macro to send automated email reminders
    By Amber12 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-13-2014, 11:22 AM
  5. Excel Macro/VBA to create multiple outlook appointments with required attendees
    By bradliggett in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-28-2013, 03:10 PM
  6. Set Up Macro to send reminders to Outlook Calendar
    By slohman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2013, 11:21 PM
  7. Replies: 1
    Last Post: 09-14-2005, 12:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1