A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

hyperlink in a form field?



 
 
Thread Tools Display Modes
  #1  
Old November 16th, 2006, 10:32 PM posted to microsoft.public.word.docmanagement
rokcet.scientist
external usenet poster
 
Posts: 1
Default hyperlink in a form field?

Is it possible to put an email hyperlink in a drop-down form field, so that
when the user picks from a selection of email addresses, the one selected
ends up as an active email hyperlink, instead of just appearing as a typed
hyperlink?
  #2  
Old November 17th, 2006, 01:58 AM posted to microsoft.public.word.docmanagement
Jay Freedman
external usenet poster
 
Posts: 9,488
Default hyperlink in a form field?

No, that isn't possible, at least not literally like you said. You'd
have to program a macro to convert the form field result to a
hyperlink.

Do you want the hyperlink to replace the dropdown (so you wouldn't be
able to change it again) or do you want it next to the field, or
somewhere else? The macro can do either, but it makes a difference.

Do you expect a click on the hyperlink to mail the document to that
address? In that case, you don't really need to insert the email
address in the form; the macro can send the document directly (see
http://www.word.mvps.org/FAQs/InterDev/SendMail.htm).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Thu, 16 Nov 2006 13:32:01 -0800, rokcet.scientist
wrote:

Is it possible to put an email hyperlink in a drop-down form field, so that
when the user picks from a selection of email addresses, the one selected
ends up as an active email hyperlink, instead of just appearing as a typed
hyperlink?

  #3  
Old November 17th, 2006, 02:29 PM posted to microsoft.public.word.docmanagement
rokcet.scientist
external usenet poster
 
Posts: 1
Default hyperlink in a form field?

The dropdown, and others, is embedded in certain cells of a team member
'roles and contacts' table. It's used to select a team member for a certain
task from a pool of team members, but since team members can change, we'd
like to be able to sometimes re-select a different team member from the pool.
So I guess we'd want the macro to convert the form field result to an email
'mailto' hyperlink, yet still leave the form field itself (the little grey
space) so we can toggle document protection on, and select a new team member,
when necessary.


"Jay Freedman" wrote:

No, that isn't possible, at least not literally like you said. You'd
have to program a macro to convert the form field result to a
hyperlink.

Do you want the hyperlink to replace the dropdown (so you wouldn't be
able to change it again) or do you want it next to the field, or
somewhere else? The macro can do either, but it makes a difference.

Do you expect a click on the hyperlink to mail the document to that
address? In that case, you don't really need to insert the email
address in the form; the macro can send the document directly (see
http://www.word.mvps.org/FAQs/InterDev/SendMail.htm).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Thu, 16 Nov 2006 13:32:01 -0800, rokcet.scientist
wrote:

Is it possible to put an email hyperlink in a drop-down form field, so that
when the user picks from a selection of email addresses, the one selected
ends up as an active email hyperlink, instead of just appearing as a typed
hyperlink?


  #4  
Old November 17th, 2006, 04:10 PM posted to microsoft.public.word.docmanagement
Jay Freedman
external usenet poster
 
Posts: 9,488
Default hyperlink in a form field?

Actually, there is a way to do what you want. It's called an AutoTextList
field, and the general idea is described at
http://www.word.mvps.org/FAQs/TblsFl...toTextList.htm.

The email addresses, made into hyperlinks by the AutoFormat feature, will be
the items called "your list of products" in step 4 of the article. Instead
of ProductStyle, you can name the new style something like MemberStyle.

If this is a template for a specific type of document, be sure to read the
first point under "Additional tips for advanced users".

With this method, you don't need any macro programming.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

rokcet.scientist wrote:
The dropdown, and others, is embedded in certain cells of a team
member 'roles and contacts' table. It's used to select a team member
for a certain task from a pool of team members, but since team
members can change, we'd like to be able to sometimes re-select a
different team member from the pool. So I guess we'd want the macro
to convert the form field result to an email 'mailto' hyperlink, yet
still leave the form field itself (the little grey space) so we can
toggle document protection on, and select a new team member, when
necessary.


"Jay Freedman" wrote:

No, that isn't possible, at least not literally like you said. You'd
have to program a macro to convert the form field result to a
hyperlink.

Do you want the hyperlink to replace the dropdown (so you wouldn't be
able to change it again) or do you want it next to the field, or
somewhere else? The macro can do either, but it makes a difference.

Do you expect a click on the hyperlink to mail the document to that
address? In that case, you don't really need to insert the email
address in the form; the macro can send the document directly (see
http://www.word.mvps.org/FAQs/InterDev/SendMail.htm).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Thu, 16 Nov 2006 13:32:01 -0800, rokcet.scientist
wrote:

Is it possible to put an email hyperlink in a drop-down form field,
so that when the user picks from a selection of email addresses,
the one selected ends up as an active email hyperlink, instead of
just appearing as a typed hyperlink?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:02 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.