Hi,

New to forum.

I have been asked to place a submit button on a word file so when this is clicked it opens outlook attaches the word file to a new email and adds the recipients address, I've managed to get the first 2 requests to work using the macro below but I can't get it to populate the email address, any help please as I'm all googled out. I've also got
another macro to run that attaches the word file and sends the email in the background but I would like the user to hit the send button manually.

Thanks

Paul

Private Sub CommandButton1_Click()
Options.SendMailAttach = True
ActiveDocument.SendMail
End Sub