Richard,
I do this stuff routinely.
If the client has an email address, email it.
If not print it.
The next step is to implement R:Fax to fax it
if I have a fax number.
Rudimentary logic
IF emailaddress IS NOT NULL THEN
email it
ELSE
IF faxnumber IS NULL THEN
print it
ELSE
fax it
ENDIF
ENDIF
Jan
-----Original Message-----
From: "Richard Croy" <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Thu, 29 Jan 2009 08:59:40 -0500
Subject: [RBASE-L] - RE: Print Option - Email On
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
