Sending Mail in Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew-9558 - 06 Mar 2008 15:42 GMT

I am about to send out a questionnaire that has been created in word, with
forms and is protected.

I have a return button to allow the recipient to return the questionnaire
(the easier the better) and a message box appears thanking them for there
time.

Private Sub CommandButton1_Click()

ActiveDocument.SendMail

MsgBox "Thank you for your reply - TMB Patterns Ltd"

End Sub

Testing this locally it works great, on a work colleagues computer the reply
button does not work...Macro settings on my machine are set to high, on
colleagues reduced this to low to try to get to work....

Any suggestions gratefully appreciated.

Reply to this Message

Doug Robbins - Word MVP - 12 Mar 2008 09:57 GMT

The macro is probably not in the document itself, but in the normal.dot
template on your machine. Hence, it is not available on your friend's
machine.

The problem that you are going to have with this is that how many of the
recipient's of your questionnaire are going to trust the macros in it and
let them run?

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am about to send out a questionnaire that has been created in word, with
> forms and is protected.
[quoted text clipped - 17 lines]
>
> Any suggestions gratefully appreciated.

Reply to this Message