[rokcet.scientist]

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?

[Jay Freedman]

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?

[rokcet.scientist]

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?

[Jay Freedman]

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?