<div>
Upload a sample workbook with some dummy data and with a layout as same as that of your original workbook.
</div>


<div>
I can recommend the commercial product that can manage it, if you want.
</div>


<div>
Here is the excel file<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/07_w29/1106942/FM-85-01-01-Customer-Feedback-Handl.xlsx" target="_blank" class="file-inline" title="FM-85-01-01-Customer-Feedback-Handl.xlsx (31 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>FM-85-01-01-Customer-Feedback-Handl.xlsx</a>
</div>


FM-85-01-01-Customer-Feedback-Handl.xlsx

<div>
Ok, ReliefJet Essentials for Outlook provides the <a href="https://www.reliefjet.com/Essentials/Features/OutlookMessagesMailMerge" rel="ugc">Mail Merge with Attachments</a> utility. It can easily handle your spreadsheet. Just add one more column that will have non-empty value if you have &quot;NO Elevated&quot; for &quot;Customer satisfaction&quot; column. Say, &quot;No Elevated&quot; and specify a formula for it. After that just save it as CSV and configure the &quot;Mail Merge&quot; utility to use it. Use the &quot;Skip row if the value is not empty&quot; option to specify the &quot;No Elevated&quot; table field. Specify other columns for recipient name, address, subject, etc. Run the utility and it will send all messages as configured.
</div>


<div>
The ReliefJet is one solution but it seems like it requires a save and then send as a file. Versus being able to send just a text email with the information.
</div>


<div>
It doesn't require to send as a file. You just provide the CSV as a datasource for mailing. You can attach any files (if needed) or you can just send text emails with the information. You can watch the tutorial video, it shows the general idea.<br />
<br />
By the way, I recommend this tool because I'm one of the developers, so feel free to ask any further questions.
</div>


<div>
It doesn't seem as if it's live interaction. The end user needs to be able to select NO elevated and then it instantly send an email without user interaction
</div>


<div>
<blockquote>
The end user needs to be able to select NO elevated and then it instantly send an email without user interaction
</blockquote>
A-ha! This is that. It was not clear in your question. I thought that you need to process the completed Excel spreadsheet by sending messages to required recipients... And by the way, are you sure you really want to send messages right away on selecting the value in the cell? I'm pretty sure that completing these fields and processing the spreadsheed by schedule is much more convenient.
</div>


<div>
Unfortunately, its the way they want it. It's the last field they will end up selecting
</div>


<div>
Hi. &nbsp;Finally had time to open the example. &nbsp;Trying to clarify. &nbsp;Do you want the email that gets sent to list all the ticket numbers that match with &quot;NO elevated&quot; ?? &nbsp;I figure you wouldn't want a separate email for every &quot;NO elevated&quot; value in the data, correct? &nbsp;Or maybe you do, and it gets sent to the email address in H2?<br />
<br />
<br />
If the type of work-arounds I listed above are not helpful, seems like VBA calling a .bat that launches powershell or something would be best. &nbsp;Maybe someone here knows better.<br />
<br />
<br />
<br />
<br />
<br />
Here is a link to read a text file or write a text file with VB in Excel.<br />
<a href="http://www.exceluser.com/excel_help/questions/vba_textcols.htm" rel="ugc">http://www.exceluser.com/excel_help/questions/vba_textcols.htm</a><br />
<br />
So now we have a way to get your data list of ticket numbers, etc., into a file.<br />
<br />
<br />
<br />
<br />
Then we have to know how to run a powershell script from a .bat file. &nbsp;Here is a description of that.<br />
<a href="http://www.howtogeek.com/204088/how-to-use-a-batch-file-to-make-powershell-scripts-easier-to-run/" rel="ugc">http://www.howtogeek.com/204088/how-to-use-a-batch-file-to-make-powershell-scripts-easier-to-run/</a><br />
<br />
And here is Microsoft's version of how to use the Send-MailMessage cmdlet in Powershell.<br />
<a href="https://technet.microsoft.com/en-us/library/hh849925.aspx?f=255&MSPPError=-2147217396" rel="ugc">https://technet.microsoft.com/en-us/library/hh849925.aspx?f=255&MSPPError=-2147217396</a><br />
<br />
And here is a helpful usage of Send-MailMessage with larger files getting piped.<br />
<a href="https://chinnychukwudozie.com/2014/11/12/powershell-script-monitors-security-logs-and-sends-email-alerts/" rel="ugc">https://chinnychukwudozie.com/2014/11/12/powershell-script-monitors-security-logs-and-sends-email-alerts/</a><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Now we have to run the .bat file from Excel with VBA which is described here below using the Shell function.<br />
<a href="https://www.experts-exchange.com/questions/20497707/Using-Shell-function-in-Excel-VBA.html" rel="ugc">https://www.experts-exchange.com/questions/20497707/Using-Shell-function-in-Excel-VBA.html</a><br />
<br />
<a href="http://answers.microsoft.com/en-us/office/forum/office_2007-excel/how-to-call-a-bat-file-through-excel-vba/7e968ef2-a290-426f-8780-ed9def3ab38d?auth=1" rel="ugc nofollow">http://answers.microsoft.com/en-us/office/forum/office_2007-excel/how-to-call-a-bat-file-through-excel-vba/7e968ef2-a290-426f-8780-ed9def3ab38d?auth=1</a><br />
<br />
<br />
<br />
Is this any help?
</div>


<div>
Hmm. &nbsp;Would anyone care if I requested the points go to me? &nbsp;Trying to stick up for myself here. &nbsp;There are some good email command syntaxes I've put into my posts here. &nbsp;They are proven and functional. &nbsp;In the original question the author said<br />
<br />
&nbsp;&quot; Ideally it send it without opening outlook but if it has to then it does.&quot; &nbsp;<br />
<br />
Some of my proven solutions open Outlook, but the author says if it has to then it does. &nbsp;In my examples I included methods for putting Excel cell values into the body of the email as the author requested, and I know it works.<br />
<br />
Also, in my post <a href="https://www.experts-exchange.com/questions/28957633/Excel-Spreadsheet-Send-email-if-certain-value-is-selected.html?anchor=a41751408&anchorAnswerId=41713176#a41713176" rel="ugc">ID: 41713176</a> &nbsp;the link to Microsoft opens to part 1, at the bottom, you click for part two and see how to use VB to email a range as here below. &nbsp;But you have to read the links.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w33/1111029/EESendEmailFromExcelWithVB.JPG" target="_blank" title="Screen Grab of Email From Excel With VB. (83 KB)"><img alt="Screen Grab of Email From Excel With VB." class="file-block lazyload" style="max-width: 630px;" data-src="https://filedb.experts-exchange.com/incoming/2016/08_w33/1111029/EESendEmailFromExcelWithVB.JPG" /></a><br />
I also included links for proven solutions to use VB to launch a batch file to run a powershell script if the author prefers to send the email with powershell rather than Outlook, or directly with VB as in the referenced &quot;part 2&quot; above.<br />
<br />
I thought I read on EE somewhere a year ago or so, that the rule of thumb was, in order to get full credit, an answerer doesn't have to write the code for the question author, simply do the guide or correct or suggest, type of thing.<br />
<br />
How do we feel about this, eh?
</div>


EESendEmailFromExcelWithVB.JPG

<div>
<div class="content wysiwyg-content">
I have this worksheet that has column that is labeled Customer Satisfaction. The options are YES and NO Elevated. If NO Elevated is selected I would like it to send an email with the information from that row's ticket number data. Ideally it send it without opening outlook but if it has to then it does. <br />
<br />
We are using Exchange 2013 so it could be just sent internally. <br />
<br />
Anyone know how to accomplish this?
</div>
</div>


I have this worksheet that has column that is labeled Customer Satisfaction. The options are YES and NO Elevated. If NO Elevated is selected I would like it to send an email with the information from that row's ticket number data. Ideally it send it without opening outlook but if it has to then it does. 

We are using Exchange 2013 so it could be just sent internally. 

Anyone know how to accomplish this?

Excel Spreadsheet - Send email if certain value is selected.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Interactions between email servers and clients are governed by email protocols. The three most common email protocols are POP, IMAP and MAPI. Most email software operates under one of these (and many products support more than one).  The correct protocol must be selected, and correctly configured, if you want your email account to work.

Email Protocols

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.