Results 1 to 1 of 1

Thread: Code to send entire workbook as an attachment in outlook using active X buttons

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    May 2020
    Posts
    1
    Rep Power
    0

    Code to send entire workbook as an attachment in outlook using active X buttons

    Hi,

    I am trying to develop a code to assist with an approval process flow. The spreadsheet is standard and users have certain fields to populate. The sheet has three Active X buttons (Send for Approval, Approved, Declined). However, both the Approved and Declined are disabled for the initial process.

    1.The 'Send for Approval' button is pressed and the excel worksheet is attached to an outlook email.
    2.The recipient of the email will open the attachment, the 'Send for Approval' button will be disabled and the 'Approved' and 'Declined' button enabled.
    3.That person should be able to press either 'Approved' or 'Declined' and this then returns an email to the original sender stating which button was pressed.

    I've tried but i was unsuccessful. Looking for a code that can help with this. The excel sheet has been attached to this post for visual representation.
    Attached Files Attached Files

Similar Threads

  1. Replies: 0
    Last Post: 01-29-2020, 05:05 PM
  2. Replies: 3
    Last Post: 02-09-2019, 08:44 AM
  3. Replies: 2
    Last Post: 06-12-2016, 12:49 AM
  4. Replies: 9
    Last Post: 07-02-2013, 06:59 PM
  5. Replies: 6
    Last Post: 06-05-2013, 11:33 PM

Posting Permissions

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