Embedding a response email addeess in Word forms

T

Tim Ellis

A wonderful find - the "Forms" facility (I thoruoughly recommend it to other
users). Have managed to set up a great questionnaire which is ready to send
out...BUT: In order to have a word doc. in forms mode, it needs to be sent to
someone as an attachment (the form fields - drop downs, tick boxes, text
boxes etc. do not work from witihn an email....). therefore Word document
needs to be sent as an attachment.
Implications : Consider when the form is finished, how does one make it easy
for the respondent to return the completed questionnaire ? Ideally, an
embedded 'button', for example, which sends the saved document (as an
attachment) to a nominated email address. The principal is fine, but in
practice.... I have worked out how to create a macro which saves and attaches
the document to an email OK i.e.
Sub Return_questionnaire()
ActiveDocument.Save
ActiveDocument.SendMail
End Sub

I can work out how to attach the macro to something e.g. one of the tick
boxes... BUT how do I have the macro fill in (automatically) the email
address (which will always be the same) that I want all the responses to come
back to ? Anyone any ideas ?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA - Want to test if Full Name is NOT Present in document 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
VBA word change keys 0
need help ASAP word 2016 recipient cant edit 0
To make pdf to work as word 1
Macro to select and delete levels of a document 2
Create a chart from a table in word thats dynamic 0
Direct emailing a word 2007 page 0

Top