How to put the link to the last created quiz in the email that will be sent to all users automatically?
<p>I could be able to let the web application sends automatic emails using Windows Task Scheduler. Now I want to put the link to last created quiz by admin in that email. <strong>How to do that? Should I add any column in the Quiz table in the database?</strong></p>

<p>The table schema:</p>

<p><em><strong>Employee Table: Username, Name, Job, Email</em></strong></p>

<p><em><strong>Quiz Table: QuizID, Title, Description</em></strong></p>

<p>My code-behind:</p>

<pre><code>protected void Page_Load(object sender, EventArgs e)
    {
        SmtpClient sc = new SmtpClient("mail address");
        MailMessage msg = null;

        try
        {
            msg = new MailMessage("xxxx@gmail.com",
                "yyyy@gmail.com", "Message from PSSP System",
                "This email sent by the PSSP system");

             sc.Send(msg);
        }

        catch (Exception ex)
        {
            throw ex;
        }

        finally
        {
            if (msg != null)
            {
                msg.Dispose();
            }
        }
    }
</code></pre>
