Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Recipient Email Link

Status
Not open for further replies.

Guest_imported

New member
Joined
Jan 1, 1970
Messages
0
Does anyone know to achieve a mailto link which will email multiple recipients, the list being a column in a database. I want the email client to open and the recipient address list to be populated with more than the one address. The list will come from a recordset which filters certain users and selects the email address field.
 
I usually asign the email address' to a variable then use the variable as the address. Live long and make your kids suffer..
 
Thanks Cheech, but can you explain how the variable will allow the selection of multiple email addresses. I know how to enable selecting multiple email addresses from a list in a form, and the results then get passed to the variable - but won't I be constrained to only one mailto in the header of the new message launched in my email client (MS-Outlook 2000)?
 
Ok I will have a go, off the top of my head....

rsEmails = SELECT email_addresses FROM tblEmails WHERE x = y
strMailto = ""
For each address in rsEmails
strMailto = strMailto + address + ;
next

<a href=&quot;mailto:' & strMailto'&quot;>mail</a>

well you get the drift Live long and make your kids suffer..
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top