Excel Template With Macro For Sending Mails And Attachment Through Outlook

[ramakrishnan]

Sir,

I have installed the latest office 2003 sp3 & the file format converters from microsoft but there was 2 errors observed

it opened a window with compile error "can't find project or library" with the highlighted line "


Yellow colour highlighted in the below code

Sub SendMessage(strTo As String, Optional strCC As String, Optional strBCC As String, Optional strSubject As String, Optional strMessage As String, Optional strAttachmentPath As String, Optional blnShowEmailBodyWithoutSending As Boolean = False)

Dim objOutlook As Outlook.Application

If time permists please asssist. We use office 2003 in office.

Thanks and Regards
R.Ramakrishnan

[Excel Fox]

One could use Late Binding, and work independent of the library being added as reference, but for the sake of performance, I have used Early Binding, which requires the reference library to be added.