This is Interesting, and I'll give it a try in a database that I'm rebuilding for a meeting registration.
What I want to do is to develop some code -- say as an exit EEP or RMD -- so that after the registration is entered and the row saved, if the registrant provided an e-mail address, R:Base would immediately, and without user intervention, send an e-mail confirmation to him/her. If the e-mail field is null, the program would print out a written confirmation letter for postal mailing. (The confirmation letter could be as an attachment to the e-mail if that would work better.) I have things pretty well figured out except the "either/or" code. Richard S. Croy [email protected] ==================================== This message has been checked with an up-to-date version of Norton Antivirus before sending, ==================================== ----- Original Message ----- From: OmaYahoo To: RBASE-L Mailing List Sent: Thursday, January 29, 2009 4:05 AM Subject: [RBASE-L] - RE: Print Option - Email On I was a little early on the button this should give you a good example! CONNECT rrbyw10 SET VAR vstatement TEXT = 'Print Invoice where TransID = ' SET VAR vtransid TEXT = '1031' SET VAR vstatement1 TEXT = 'Option PDF|FILENAME' SET VAR vpdf text = 'Invoice_1031.PDF' SET VAR vstatement2 TEXT = '|EMAIL ON|EMAIL_TO_LIST' SET VAR vemaillist TEXT = '[email protected], [email protected]' set var vstatement3 text = '|EMAIL_FROM_NAME Oma Cox|EMAIL_FROM_ADDRESS [email protected]' SET VAR vstatement4 TEXT = '|EMAIL_SUBJECT Imagine The Possibilities!|EMAIL_BODY attach IS THEN invoice sent via r:base. because we can!|EMAIL_ATTACHMENTS PoupupMenusONOFF.frm#PoupupMenusONOFF.lob|EMAIL_DELETE_AFTER_SEND ON|EMAIL_SHOW_DIALOG OFF' SET VAR vfinal = (.vstatement+.vtransid&.vstatement1&.vpdf+.vstatement2&.vemaillist+.vstatement3+.vstatement4) &vfinal RETURN Best Regards, Oma Cox O.C. Services Inc. P.O. Box 5485 Brandon, MS 39047 662.820.7599 601.992.6785 www.ocservicesinc.com ------------------------------------------------------------------------------ From: [email protected] [mailto:[email protected]] On Behalf Of Gary Wendike Sent: Wednesday, January 28, 2009 11:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Print Option - Email On In using the new EMAIL ON option for the PRINT command, does the EMAIL_TO_LIST require the input to be actual emails or can the emails be listed via a variable? Example from help file -- CONNECT RRBYW10 PRINT Invoice WHERE TransID = 1031 + OPTION PDF|FILENAME Invoice_1031.PDF + |EMAIL ON + |EMAIL_TO_LIST [email protected], [email protected] + Can these be defined variables as well? |EMAIL_FROM_NAME John D. Johnson + |EMAIL_FROM_ADDRESS [email protected] + |EMAIL_SUBJECT Imagine The Possibilities! + |EMAIL_BODY Attached is the invoice - sent via R:BASE. Because we Can! + |EMAIL_ATTACHMENTS C:\Letters\otherstuff.pdf#C:\Letters\morestuff.pdf + |EMAIL_DELETE_AFTER_SEND ON + |EMAIL_SHOW_DIALOG OFF RETURN This, by the way, is a great option if the variables can be used. Thanks Gary
