Macro to attach an additional file to and outlook email

[Groovicles]

Hi everyone,

I have the following code:

Please Login or Register  to view this content.

This code as it is works perfectly. Its a attached to a button, and whne its pressed, the workbook is automatically attached ot an email and then emailed to the desired address.

What I'm trying to do is have Windows File Explorer open up when the button is pressed so the user can add additional attachments to that same email with the current workbook attached and then sent to the address (currently shown as a hotmail address) automatically. So in effect, the email being sent automatically would have 2 attachments: 1 being the workbook, and the 2nd being whatever additional file the user wants, and sent automatically to the address in the code.

Any ideas?

Thanks!!

[Groovicles]

I think I got it working. For those who are interested:

Please Login or Register  to view this content.