Need code to attach a file to outlook

[btroupjr]

I know this may sound redundant, but it's not. (I think)
I need code to allow a user to click an object, enter in a file name, hit enter,... and the macro will find the file in a specified folder, and attach the file in an outlook 2007 email. The recipients listed will be in an excel named list.
Any ideas?

Thanks everyone, I am glad I found this forum!

:beerchug:

[JP2112]

What sort of "object" did you mean? An image?

--JP


I know this may sound redundant, but it's not. (I think)
I need code to allow a user to click an object, enter in a file name, hit enter,... and the macro will find the file in a specified folder, and attach the file in an outlook 2007 email. The recipients listed will be in an excel named list.
Any ideas?

Thanks everyone, I am glad I found this forum!

:beerchug: