Email attachments possible??

[aaronp]

Is it possible to attach a file to an outlook email from an excel macro? I know you can attach the active worksheet but can you attach a totally non related file??

I know this doesn't work, just hoping this will help you understand what I am talking about.

Example:

With OutMail
        .To = ""
        .CC = ""
        .BCC = ""
        .Subject = Range("AI6")
        .Body = "See attachment for sample results."
        .Attachment = ("C:\Users\Desktop\ThisFile.doc")
        .Display
    End With