+ Reply to Thread
Results 1 to 1 of 1

Need help in automating ms form data collection to trigger email based on conditional form

  1. #1
    Registered User
    Join Date
    05-15-2019
    Location
    India
    MS-Off Ver
    MS-office 10
    Posts
    1

    Question Need help in automating ms form data collection to trigger email based on conditional form

    I have a Microsoft Form shared with my Global Distributors, containing few inventory and safety protocol related questionnaire.
    few input choice values are:
    Below 5
    5 - 10
    Not Available
    1
    2
    Yes
    No
    Feedback text

    Depending on the above choice my data gets conditional formatting.

    I want to create an automate version where it triggers automatic email to the respective region head, country head and other regional supv regarding the red highlighted data with Item header of that specific distributor of that region do not share all data (privacy) in the email message body alert " please check on the below items with the distributor. "

    Can anyone help, it should trigger the email as soon as the backend excel linked with Microsoft form gets updated with new value and for conditioned red ones only.
    If any distributor submit the form the excel gets updated

    PLEASE MIND IT SHOULD NOT REPEAT EMAIL THE OLD DISTRIBUTORS IT HAS ALREADY SHARED IT SHOULD ONLY CHECK THE NEW ENTRY DONE BY DISTRIBUTORS
    Attached Files Attached Files

+ 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. VBA for order form data collection - part working
    By pleb123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2018, 04:29 PM
  2. auto email form excel imputting specific row data for each email address + add graph
    By macroconfused in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2018, 01:59 AM
  3. Automating an email once form is submitted (access 2013)
    By TapiwaMaseko in forum Access Tables & Databases
    Replies: 0
    Last Post: 09-03-2017, 03:52 PM
  4. User Form - How to determine Multiple Page show based on 1 point trigger
    By Shermaine2010 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-27-2016, 03:21 AM
  5. Trigger message box after user updates VBA form based on data calculated in a cell
    By blackelvis73 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2016, 12:51 PM
  6. Looping a data input form based on form option
    By bologne in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 04-17-2011, 03:06 AM
  7. how do i create a data collection form in excel?
    By stacy in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-26-2005, 04:05 PM

Tags for this Thread

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