Hello All,

I am new to VB and have no real idea on how to do this. I have bought 3 different books, and am still lost. I am hoping that someone has already created a similar macro, and doesn't mind sharing.

This is my situation. I have a drop down menu and when i select an item in the drop down menu I want a file or files to be associated with it. I then want to be able to click on that file to have it emailed to someone. So basically when you click on it it, it attaches itself to a new email in outlook, but that window comes up. All I would need to do is to input an email address.

Can anyone help?

Thanks