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

    Need a script to open a template, create a log, and create an outlook calendar reminder


    I'm looking to devise an excel VBA script which will open an existing Microsoft Word Template, create a Log and finally set an Outlook reminder to review the created document in 6 months time.

    This will all be triggered with a click of a button.

    The Log will detail who created the document and when it was done, this would need to be in a non-editable format.

    Any help would be greatly appreciated.

    Thank you in advanced.

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Melbourne, Victoria, Australia
    Thanked 295 Times in 267 Posts
    Have you made any attempt at this yourself? You can do web searches for the three main components of your request and it would be good to know what you have explored so far.

    Note that in order to specify the document which needs review, the new document will have to be saved first and still be there with the same name in six months time. Is this realistic?

    Where should the log be stored? If it is in the same Excel workbook then I guess you will need to lock down that worksheet to make it a non-editable format.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Tags for this Thread

Posting Permissions

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