+ Reply to Thread
Results 1 to 1 of 1

Macro to trigger, when date becomes current, a calendar event in outlook?

  1. #1
    Registered User
    Join Date
    03-05-2015
    Location
    Ignacio, CO
    MS-Off Ver
    Office 20070
    Posts
    1

    Macro to trigger, when date becomes current, a calendar event in outlook?

    Hi all,
    I have an Excel 2007 spreadsheet which I use, in addition to storing child screening data, to store dates those screenings are due - that I use (rather ineffeciently) as a tickler.

    What I would REALLY like to do is have some kind of a macro (I suppose it would be a macro; I'm not too savvy) to cause a calendar event (preferably an all day event) to be created in my Outlook (2007), when the date something is due (say, in Cell 1) matches the current date (which is in another cell, say cell 2). AND, I'd like the identifying information (say, in cell 3) to become the text associated with the calendar entry.

    I've attached a small sample Excel spreadsheet (Sorry it's a JPEG visual), with the three relevant cells (referenced above) highlighted as Green (cell 1), Blue (cell 2), and yellow (cell 3).

    Anybody know how to do this? Thanks to all of you wizards who share your wisdom.

    HS_ECSE
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 06-28-2014, 09:31 AM
  2. Embedding a link to add and event to Outlook Calendar
    By IheartIUP in forum Excel General
    Replies: 0
    Last Post: 05-08-2014, 11:11 AM
  3. VB Calendar Macro to highlight current date
    By jlcford in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-10-2008, 02:00 PM
  4. Using Excel to generate an Outlook Calendar Event
    By Michael in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2006, 04:30 PM
  5. trigger event if any data in modified on ONLY the current workshee
    By CRayF in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-23-2005, 05:05 AM

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