PDA

View Full Version : Macro button in word



Binkx
08-22-2016, 04:15 AM
Hi

I have created a word form that needs to be attached to an email when the button is clicked.


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

what do I need to add, to get an email address added automatically in the 'To' of the email.?

thanks in advance.

gmayor
08-22-2016, 04:58 AM
Basically you can't. If you are certain that all your users have Outlook you can use the Outlook object to create a message and attach the document.