>>>

Dim SQLCon As New SqlClient.SqlConnection
>>>        Dim SQLCmd As New SqlCommand
>>>
>>>        SQLCon.ConnectionString = "Data Source=name;Integrated Security = True;"
>>>        SQLCon.Open()
>>>
>>>        SQLCmd.CommandText = "Exec StandardNamesUpdate"
>>>        SQLCmd.Connection = SQLCon

>>>
>>>I don't think that's working though. I'll try to look into the ExecuteNonQuery method.
>>
>>The above is not very good example. Try this one (first result in BING):
>>http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson07.aspx
>>
>>Using Google also doesn't seem to bring good VB.NET examples - all examples I found so far were C#. Anyway, another one
>>http://www.codeproject.com/KB/cs/simplecodeasp.aspx
>
>
>The second link was pretty badly formatted and looks to have incorrect code in places, but I mixed and matched some stuff and came up with this:
>
>

SQLCon.ConnectionString = "Data Source=server;Initial Catalog=database;Integrated Security = True;"
>        SQLCon.Open()
>        SQLCmd = New SqlCommand("StandardNamesUpdate", SQLCon)
>        SQLCmd.CommandType = CommandType.StoredProcedure
>        SQLCmd.ExecuteNonQuery()
>        SQLCon.Close()
>

>
>When I run the program it pauses about as long as it takes for the SP to run in SQL Server, and then my e-mail is generated so it may be working. Now I need a way to check to see if it's working for sure, can I assign it to a text box and have it show me the number of rows affected? After that, how do I get it to copy the results of the second SP so I can have it pasted into the e-mail?

You may want to do a bit more reading on ADO.NET methods and go through examples in MSDN. I made another quick Bing search, found this link that provides more links - you may want to start from them
http://wonald.com/ado-net-performance-executereader-vs-executenonquery-vs-executescalar-93.htm