Re: A little help on e-mail (HELP!!! :-) )
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19200
interpreted = N
texte = >How can I get the E-MAIL field contents to be picked up from the database>and become the e-mail address that mail is sent to??We finally hashed this out, and in case anyone is curious, theall-important missing part of his question was this:I want to send one email per *lineitem*, and the address of who to send itto is a field called [E-MAIL] in my *product database*This is a cool idea, but since it was somewhat unusual, none of the helpfulpeople on this list could figure out why it was so difficult. Here's theanswer, based on ThankYou.tpl from GeneralStore:[LineItems][include file=Fulfillment.txt&v.email=[E-MAIL]][/LineItems]Notice the [E-MAIL] field comes from the product database, and isautomatically looked up based on the sku of the lineitem. In this case,each item in the product database belongs to a different vendor, and thisis how they are notified that someone wants to buy their stuff.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>How can I get the E-MAIL field contents to be picked up from the database>and become the e-mail address that mail is sent to??We finally hashed this out, and in case anyone is curious, theall-important missing part of his question was this:I want to send one email per *lineitem*, and the address of who to send itto is a field called [E-MAIL] in my *product database*This is a cool idea, but since it was somewhat unusual, none of the helpfulpeople on this list could figure out why it was so difficult. Here's theanswer, based on ThankYou.tpl from GeneralStore:
[lineitems][include file=Fulfillment.txt&v.email=[E-MAIL]][/LineItems]Notice the [E-MAIL] field comes from the product database, and isautomatically looked up based on the sku of the lineitem. In this case,each item in the product database belongs to a different vendor, and thisis how they are notified that someone wants to buy their stuff.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Problems with [Applescript] (1997)
WebDNA 5.1 and Mac OS X Server v10.3 - Working ??? (2003)
[WebDNA] form data compared to existing database (2016)
WebCat2b13MacPlugIn - syntax to convert date (1997)
[WebDNA] Unofficial WebDna 6.2 and 7 - Mac Mavericks Installer (2014)
Need relative path explanation (1997)
Emailer Problem (1998)
small hairball -- stuck on [showif] for related db (1998)
[WebDNA] Adding Graphics to Directory (2009)
WebCat2 beta 11 - new prefs ... (1997)
shipcost (1997)
(1997)
Users.db (1998)
test (2003)
webcat restarting script on Linux? (1999)
[Announce] WebCatalog 3.0 Beta Program (1998)
Replace context problem ... (1997)
pictures / referrer etc. (1998)
Re:Emailer tracking (1997)
Thanks Grant (1997)