How to let the web application sends automatic emails with the link to the last created quiz in the system?
<p>I am a new ASP.NET developer. I need to develop the web application to be able to send emails automatically everyday at 7am. I know how to do that using Windows Task Scheduler. All what I need to do is creating a page that contains a script which send emails to all users in the database with link to the last created quiz in the database. 
The schema of the tables:</p>

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

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

<p><strong>Question Table: QuestionID, Question, Answer1, Answer2, Answer3, CorrectAnswer, QuestionOrder, QuizID.</strong></p>

<p>Now, I could be able to send emails by creating a page that contains the required code for sending</p>

<p>email in the Page_load method, but I don't know how to include the link of last created quiz in this email, in addition, to the emails of the users. How to do that?
My Code-Behind is: </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>
