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:
The code for the Userform:
Thanks,
Daniel
Bookmarks