¿ªÔÆÌåÓý

  1. GroupManagersForum
  2. Topics

Email column in database table #database

 

What is the best type for an email column in a database table?? Will it be clickable
 

On Sat, Nov 16, 2019 at 08:28 PM, Suzanne H wrote:
What is the best type for an email column in a database table?
Use a data type of "Link" and enter the URL as "mailto: myaddress @ domain.net" (without the quotes or spaces).

Will it be clickable?
If you do everything as I suggest above, a mouseclick on the link should open your default email client and open its message editor with the target address pre-populated in the To: field.

Bruce
 

On Sat, Nov 16, 2019 at 08:28 PM, Suzanne H wrote:
What is the best type for an email column in a database table?
And Bruce responded:
Use a data type of "Link" and enter the URL as "mailto: myaddress @ domain.net" (without the quotes or spaces).
Will it be clickable?
If you do everything as I suggest above, a mouseclick on the link should open your default email client and open its message editor with the target address pre-populated in the To: field.

Bruce

If you want to get fancy, you can pre-populate the email Subject and/or Body, too. Here's an example:
mailto:joe@...&subject="Important message from My Group"&body="Here is an important message for you today. Please respond promptly."

Most mail agents will leave the insertion point right after the pre-populated body text, although the user can change both the subject and body text.

1 - 3 of 3