send form by email
- From: Bob <wickham_bob@xxxxxxxxxxxx>
- Date: Fri, 17 Aug 2007 09:39:30 +1000
Hi,
I hope I have the right forum. I think there used to be a dedicated forms forum but I can't seem to find it.
I have created a normal form (not a user form) in a normal Word document.
I have created a Command button from the Controls Toolbox toolbar
I want to be able to send the whole document via email using the Click event of the command button like this:
Private Sub CommandButton1_Click()
ActiveDocument.SendForReview _
Recipients:="someone@xxxxxxxxxxx", _
Subject:="Please review this document.", _
ShowMessage:=True, _
IncludeAttachment:=False
End Sub
Trouble is, as soon as I create the command button (even before writing the above code) my form ceases to work. It instantly loses protection and ceases to behave like a form.
In fact, the form still refuses to work even after deleting the command button.
I've tried putting the form and the button in different sections (Insert>Break>Continuous) but this hasn't made any difference.
It would seem that I need to programmatically Un-protect and then re-protect but the behaviour of the form after the creation of the command button makes that futile.
Without the form, the command button works
Without the button, the form works.
Any suggestions greatly appreciated.
Bob
.
- Follow-Ups:
- Re: send form by email
- From: Bob
- Re: send form by email
- Prev by Date: Re: Keyboard equivalent to double-click to select word
- Next by Date: Re: Short VS Long dash
- Previous by thread: Keyboard equivalent to double-click to select word
- Next by thread: Re: send form by email
- Index(es):
Relevant Pages
|