vba to convert sheet to PDF file and attach it to outlook

dear ,
i have an Excel sheet 2007 , i need a VBA to convert it to PDF file and Attach it on Oultook , and automatically insert the Mail Recipients ( To... and CC... ) ,( the outlook connecting to the server of company ) .

any Idea ?

the subject must be the value of cell ("A7")

dear,
i found the attached file in this forum , but when i use it , it gave me run-time error:5 and yellow label on the line : #ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
MyFilePath & MyFileName, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
False#
why doesn't work with me ? i use windows 7 and excel 2007 ?

need help