Email field to start with "mailto:"

[CW]

At present we have to prefix any email address with "mailto:" in order for it
to fire up Outlook when clicking on it.
Would it be possible to have this as a default prefix or a "partial mask" so
that it was always there at the start of the field, and all we would have to
do would be to add in the actual email address itself?
Thanks
CW

 

[fredg]

At present we have to prefix any email address with "mailto:" in order for it
to fire up Outlook when clicking on it.
Would it be possible to have this as a default prefix or a "partial mask" so
that it was always there at the start of the field, and all we would have to
do would be to add in the actual email address itself?
Thanks
CW

Code the AfterUpdate event of the control you enter the address in:

Me![ControlName] = "Mailto:" & [ControlName]

Better yet, using a regular Text datatype field, enter the address
normally, i.e. (e-mail address removed)
Then, code the control's Double-click event:
Application.FollowHyperlink "MailTo:" & [ControlName]

Double-click in the control and an email message will be opened
already addressed.

 

[CW]

Ah, great. And I'm glad it was you that answered, Fred, as your suggestions
always seem to work!!
Thanks a lot
CW

At present we have to prefix any email address with "mailto:" in order for it
to fire up Outlook when clicking on it.
Would it be possible to have this as a default prefix or a "partial mask" so
that it was always there at the start of the field, and all we would have to
do would be to add in the actual email address itself?
Thanks
CW

Code the AfterUpdate event of the control you enter the address in:

Me![ControlName] = "Mailto:" & [ControlName]

Better yet, using a regular Text datatype field, enter the address
normally, i.e. (e-mail address removed)
Then, code the control's Double-click event:
Application.FollowHyperlink "MailTo:" & [ControlName]

Double-click in the control and an email message will be opened
already addressed.

 

[fredg]

Ah, great. And I'm glad it was you that answered, Fred, as your suggestions
always seem to work!!
Thanks a lot
CW

At present we have to prefix any email address with "mailto:" in order for it
to fire up Outlook when clicking on it.
Would it be possible to have this as a default prefix or a "partial mask" so
that it was always there at the start of the field, and all we would have to
do would be to add in the actual email address itself?
Thanks
CW

Code the AfterUpdate event of the control you enter the address in:

Me![ControlName] = "Mailto:" & [ControlName]

Better yet, using a regular Text datatype field, enter the address
normally, i.e. (e-mail address removed)
Then, code the control's Double-click event:
Application.FollowHyperlink "MailTo:" & [ControlName]

Double-click in the control and an email message will be opened
already addressed.

Re: > as your suggestions always seem to work!!

Please tell that to my wife!!!