GPSPOW

<div>
Let me try my powershell application.<br />
<br />
I'll let you know.<br />
<br />
Thanks<br />
<br />
Glen
</div>


Let me try my powershell application.

I'll let you know.

Thanks

Glen

<div>
Using the attached link and other reference articles I was able to accomplish my task of &nbsp;setting up a conditional test and then emailing an attachment I created from one of my SQL scripts.<br />
<br />
Thanks<br />
<br />
Glen
</div>


Using the attached link and other reference articles I was able to accomplish my task of  setting up a conditional test and then emailing an attachment I created from one of my SQL scripts.

Thanks

Glen

<div>
Great, glad that worked for you! <br />
<br />
Sometimes I love PowerShell, it can really make tasks easy. <br />
<br />
Take care,<br />
<br />
Jon
</div>


Great, glad that worked for you!

Sometimes I love PowerShell, it can really make tasks easy.

Take care,

Jon

<div>
Please close question.<br />
See my comments above.
</div>


Please close question.
See my comments above.

<div>
Hello, isn't there a button to accept my answer as a solution?
</div>


Hello, isn't there a button to accept my answer as a solution?

<div>
I just check it as helpful.<br />
<br />
I do not see any other buttons.<br />
<br />
Thanks<br />
<br />
Glen
</div>


I just check it as helpful.

I do not see any other buttons.

Thanks

Glen

<div>
<div class="content wysiwyg-content">
I would like to use a batch file to send an email via a SMTP mail server with attachments.<br />
<br />
I have all the settings because I use the SMTP within my SQL server. &nbsp;The purpose of this &nbsp;batch file is to take a 'txt' file and forward it to a recipient. &nbsp;One other wrinkle is that it has to be conditional based on the value within a file, Y or N.<br />
<br />
Is this possible?<br />
<br />
Thanks<br />
<br />
Glen
</div>
</div>


I would like to use a batch file to send an email via a SMTP mail server with attachments.

I have all the settings because I use the SMTP within my SQL server.  The purpose of this  batch file is to take a 'txt' file and forward it to a recipient.  One other wrinkle is that it has to be conditional based on the value within a file, Y or N.

Is this possible?

Thanks

Glen

Email via SMTP from Batch File

Microsoft Disk Operating System (MS-DOS) was an operating system for x86-based personal computers, and traces of it are still found in the Windows operating system. DOS is still used in some embedded systems and for certain legacy 16-bit networks.

Microsoft DOS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.