Sending Outlook Attachments with VBA

I am using the code below to select a recipient and attach the corresponding attachment. I am getting an error saying that the oject does not allow this and the code seems to stop at the line directly following. What do I need to change?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi,

Untested but probably because you've Dimmed 'attacher' as a Workbook object. The .Add instruction is expecting to see a string reference which should be the complete drive\path\folder\filename.

That may in fact be your existing attstr variable but I can't tell whether this includes the full drive\path\folder string.

HTH

I doubt you can attach an open workbook using this method (sending open files generally warrants SendMail which is limited in terms of other functionality like body etc...)

edit: probably wrong though...