VBA to save worksheet as a pdf and email

I have a workbook that I would like to save 2 of the worksheets (Test Record and Data Transfer) as pdf and email them.

Menmine,

There are lots of solutions to this problem on the internet. Here's a few links that should help you get started:
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
http://www.rondebruin.nl/pdf.htm
http://www.ozgrid.com/forum/showthread.php?t=155639
http://www.mrexcel.com/forum/showthread.php?t=466247