Emailing a snapshot of the userform?

Hi All

is there a way to email or attach to an email a snapshot of a userform?

I have so far this code......

Please Login or Register  to view this content.

and then this allows me to print the userform by using this in a command button

Please Login or Register  to view this content.

but i want to be able to email the form, and changing "print" to "email" or "outlook" doesnt seem to be working, obviously removing pagestup calls too

This line ActiveWindow.SelectedSheets.PrintOut Copies:=1 i would of thought i could change to "send" but theres no option

Would anyone know, im hopeful its an easy change to make

Thanks

Dan

Thanks for the reply, i have just managed to do it pretty much like you suggested

Please Login or Register  to view this content.

I just removed the pagesetup code and replaced it with senmail line to attach the newly created workbook of the snap shot, works perfectly