View Single Post
 
Old 07-07-2015, 09:31 PM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Adding a button to run a macro is easy enough, but the biggest obstacle that you have to overcome is that in order for this to work, the user must allow the macros necessary to achieve it to run, and you cannot force that.

If the form is not created on a web site to be filled on line, I would be inclined to send out the form as an e-mailed attachment and include an instruction to return the form to you as an attachment. You can include a hyperlink - and it might be better not to encourage the user to change the subject as it makes it much easier to identify the returned messages for processing, if they all have the same subject, to which end you should find http://www.gmayor.com/ExtractDataFromForms.htm useful.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote