Consulting

Results 1 to 2 of 2

Thread: APPROVE/REJECT command button reply email

  1. #1
    VBAX Newbie
    Joined
    Jun 2018
    Posts
    1
    Location

    APPROVE/REJECT command button reply email

    Hi all,
    I am trying to find examples but not sure I am on the right track.

    I have built a form in Outlook which includes an APPROVE and REJECT command buttons.
    Clicking the APPROVE button from the receivers end would return an email to sender, where I need help?:
    - code for the command button to run macro to send email
    - code to reply to the sender of the original email
    - entering other recipients email addresses into the code (this will be a static list, so I am happy to hardcode the recipients into macro)
    - entering a generic reply message into the code

    (basically clicking accept will prepare and send the email back without need to add any further details to email)

    Clicking REJECT button will do the same as above.... but the generic message will have lines of text to add further details.

    many thanks.

  2. #2
    This has no end of practical difficulties - not least of which are that you have no control over what the recipient may use to read the e-mails, and that you cannot ensure that the recipient will allow macros to run or send the replies.

    You should use hyperlinks for the buttons either to send messages directly, though there are limits as to what you can do with hyperlinked e-mails, and the user still has to send the message back, or you can link to a web site where you can store the responses and any processes required. http://www.gmayor.com/EMail_Response.htm may help with that.
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

Posting Permissions

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