Input box to search column for value & generate email

Hi,

Below is a subroutine that utilizes a userform to do what you described. I have assumed you use Microsoft Outlook for the e-mail, but there is a part I have used for Thunderbird, so I think it would work with other e-mail clients. Depending how your e-mail client's security settings are set, it could take a little editing to get it to work smoothly. I actually use Thunderbird and prefer the second option for myself.

I have attached the worksheet I used to put the subroutines together so you can see it work. The routine will run by pressing "<CTRL> a".

The main subroutine:

Please Login or Register  to view this content.

The code for the Userform:

Please Login or Register  to view this content.

Thanks,

Daniel