+ Reply to Thread
Results 1 to 3 of 3

VBA Direct Replies To Different People Based on Voting Button Response

  1. #1
    Registered User
    Join Date
    10-03-2014
    Location
    Nashville
    MS-Off Ver
    2010
    Posts
    1

    VBA Direct Replies To Different People Based on Voting Button Response

    I am sending an email via late binding through an Excel template. I have added voting buttons to the template and it works fine. I would like to be able to route the email to different recipients if the user has a voting button response does not select "Approved". Is there a way to program the email coming from Excel to have voting options associated with how the user responds to the voting buttons?
    With OutMail
    .To = "bossemailaddress"
    .CC = ""
    .BCC = ""
    .Subject = "~TEST~ email”
    .HTMLBody = RangetoHTML(rng)
    .votingoptions = "Approved; More Info Needed"
    '///// HELP NEEDED HERE /////
    If .votingresponse = "Approved" Then
    .ReplyRecipients.Add (originalemailreceipient)
    Else
    .ReplyRecipients.Add (originalemailreceipient)
    .ReplyRecipients.Add (Newemailreceipient)
    End If
    '/////
    .Send
    .Delivery = True
    End With

  2. #2
    Registered User
    Join Date
    09-30-2015
    Location
    Sao Paulo, Brazil
    MS-Off Ver
    Office 2010
    Posts
    1

    Re: VBA Direct Replies To Different People Based on Voting Button Response

    Hi there, i got the same problem...but I need also to attach the original file that was previously sent in the first message...

    is there another way, maybe to forward the original message depending on the voting option?

    Tks

  3. #3
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: VBA Direct Replies To Different People Based on Voting Button Response

    CassioCarvalho

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

+ 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. [SOLVED] Outlook Voting button
    By Andrew in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-21-2006, 01:10 AM
  2. [SOLVED] Voting Response
    By junoon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2006, 08:55 PM
  3. [SOLVED] Is there any way to use a voting button in excel?
    By mmonk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2005, 10: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