Excel 2013 - VB Script to save and e-mail form RRS feed

  • Question

  • Hi All

    I hope I will be clear in my query and that someone is able to understand it and assist accordingly.
    I currently have an excel document that serves as an Access Control Matrix. In it I have tick boxes for item selection and a button labelled "Submit". I would like the "Submit" to do the following:

    1. save and send the information entered on the spreadsheet to a specific e-mail address in excel or csv format
    2. clear all tick boxes upon hitting the "submit" button.

    Not sure if this would make any difference but the document will be hosted in a SharePoint repository.

    P.S - I am a novice Excel user.

    Monday, February 15, 2016 6:40 AM