Word - word 2007 form email button VBA
Asked By WillowK22
08-Feb-10 01:04 PM
I have a "submit" button on a form that I want to send to only one recipient.
What should the VBA code for the button be?
Graham Mayor replied to WillowK22
Insert a Hyperlink to the e-mail address e.g.
{ HYPERLINK mailto:yourname%40yourISP.com?subject=Returned%20Form }
%40 = @
%20 = 'space'
with a suitable display text e.g. "CTRL+Click Here to return the form"
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Hyperlink problem in vba Word I'm writing a Word VBA function that process hyperlinks within word documents. Since Work can also convert web sites into hyperlinks as well, I check that the Hyperlink.Address property begins with "mailto" to make sure I only process email addresses. Here's a sample of my code AutoFormat For Each HLink In objDocument.Hyperlinks E_Mail = Split(HLink.Address, ":", 1) If E_Mail(0) = "mailto" Then . . . . Endif . . . . . . Endif The problem is that I get an error on the third line hyperlinks in the document. Can anyone shed some light on this? Thanks in advance Ray Word VBA Discussions Microsoft Word (1) Word (1) WdAllowOnlyFormFields (1) HLink.Address (1) ObjDocument.Range.AutoFormat
How to replace OLE in Word? Word How to see source object in Word? / OLE, please vanish! / 1) z.B. How to get an underlined blue text and to click on it and to send E-mail INSTEAD OF having this in Word doc: {HYPERLINK "mailto:oat@defgo.ru" }? 2)z.B. How to see real picture instead of reading this EMBED MSPhotoEd.3} ? Thank you! Word VBA Discussions Microsoft Word (1) Word (1) Alt (1) Mailto (1) OLE (1) Oat (1) Press Alt+F9 to
differences between vba on Word 2003-2007 (Win) and Word 2004(Mac) Word I have a VBA application that is working well on Word 2003 and 2007 for Windows and some of it works on Word 2004 for the Mac. My question is: Where can I find a list of differences in vba between Word 2003 (Win) and Word 2004 (Mac)? Any assistance would be gratefully received, PeterEvans
error message"this command is not available in this version of Microsoft Word" Word Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel MAC Office Word Discussions Office XP (1) Microsoft Word (1) Word 2010 (1) Word 2007 (1) Word 2003 (1) Office (1) Excel (1 VBA (1) Hi, I guess the important questions are: how up-to-date are both Word