Steve,
SET VARIABLE VFILENAME = 'TEST.PDF'
SET VARIABLE V1 TEXT = ID1 IN TRANS WHERE INVNO = .VRESPONCE
SET VARIABLE V2 TEXT = EMAIL IN CUSTOMER WHERE ID1 =.V1
SET VARIABLE VRESPONCE = ('c:\EXPORT\'+.VFILENAME)
PRINT RENEW03 WHERE INVNO = .VRESPONCE +
OPTION PDF|FILENAME .vresponce +
|EMAIL ON +
|EMAIL_HOST [email protected] +
|EMAIL_USERID [email protected] +
|EMAIL_PASSWORD xxxx+
|EMAIL_TO_LIST .v2 +
|EMAIL_FROM_NAME example +
|EMAIL_FROM_ADDRESS [email protected] +
|EMAIL_SUBJECT test +
|EMAIL_BODY (message and .RDATE1) +
|EMAIL_ATTACHMENTS .vresponce +
|EMAIL_PORT 25 +
|EMAIL_AUTHENTICATION ON +
|EMAIL_DELETE_AFTER_SEND off +
|EMAIL_SHOW_DIALOG OFF
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
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Steve
Johnson
Sent: Friday, January 16, 2009 6:46 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: E-mail 7.6
To All:
I have been experimenting with the e-mail capability of Rbase 7.6
but have run into a few problems. The biggest is whether one can
pass a variable to the |EMAIL_TO_LIST parameter (to pass an e-mail
address from the database). I placed a dotted variable in place of a
hardcoded name, defining the variable earlier that is captured when I
SHO VAR, but the e-mail process fails. A hardcoded email address in
|EMAIL_TO_LIST does allow the e-mail process to be
successful. However, in the received e-mail, curiously, there are
two attachments, rather than one as listed |EMAIL_ATTACHMENTS
C:\export\.vresponce.pdf. Also curious is that the .pdf extension
shown in the email is lower case in one and upper case in the
other. I also have a variable (rdate1) in the message section that
is passed through successfully, but in the received e-mail, it has
single quotes around the printed variable. I suppose this may be
related to the set quotes command.
So how do I pass a variable to the |EMAIL_TO_LIST and why two
attachments rather than one.
R:Thanks
Steve
SET VARIABLE V1 TEXT = ID1 IN TRANS WHERE INVNO = .VRESPONCE
SET VARIABLE V2 TEXT = EMAIL IN CUSTOMER WHERE ID1 =.V1
PRINT RENEW03 WHERE INVNO = .VRESPONCE +
OPTION PDF|FILENAME c:\export\.vresponce +
|EMAIL ON +
|EMAIL_HOST [email protected] +
|EMAIL_USERID [email protected] +
|EMAIL_PASSWORD xxxx+
|EMAIL_TO_LIST .v2 +
|EMAIL_FROM_NAME example +
|EMAIL_FROM_ADDRESS [email protected] +
|EMAIL_SUBJECT test +
|EMAIL_BODY (message and .RDATE1) +
|EMAIL_ATTACHMENTS C:\export\.vresponce.pdf +
|EMAIL_PORT 25 +
|EMAIL_AUTHENTICATION ON +
|EMAIL_DELETE_AFTER_SEND off +
|EMAIL_SHOW_DIALOG OFF
RETURN
