Excel Automatic Email - VBA/ Macros/ Programming

Hello all,
I am interested in learning if there is a way to make my spreadsheet do the following once a day automatically:
- Email 1 sheet from the spreadsheet in .PDF format by itself at 5pm Monday - Friday.

If this is possible, i would love to learn how.

Thank you

JieJenn's link shows you how to schedule tasks.
You can use the scheduler open a xlsm file.
The xlsm file could perform some macros when it opens.

As for the emailing, this first link uses an SMTP server:
http://www.cpearson.com/excel/Email.aspx

And this second link uses the Outlook object instead. It only works on computers with Outlook installed though:
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx