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?

Insert a Hyperlink to the e-mail address e.g.

Graham Mayor replied to WillowK22
09-Feb-10 02:12 AM
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
Post Question To EggHeadCafe