Paste Excel Userform Screenshot into Word document

Hi,

Hopefully this is a quick easy question for someone here.

I have a test userform (which has 3 command buttons).

The first commandbutton takes a print screen of the userform.

The second commandbutton opens an outlook email with the userform print screen in it.

And the third userform ideally opens a word document with the userform print screen in it.

I've done the first two commandbuttons but I'm unable to work out how to do the third one.

Can anyone help me with this?

The reason I have a separate command button just to take a print screen is because I was unable to combine taking a print screen and opening an outlook email/word document under one command function. But if you are able to combine the functions so that I have only two commandbuttons (one for outlook email and one for word document) that would be extremely helpful.


Many Thanks.