In using the Email On Option for the print command, can you send more the
printout as an attachment? The examples I have seen indicate using "#" between
the files that are being sent as an attachment, however, I cannot get more than
one attachment to be sent. That attachment is only the one that is printed as
specified within the print command.
I have the following code that I am trying to use for the print command...
*(File setup for Welcome letter)
SET VAR vdir = (CVAL('currdir'))
SET VAR vfile1a = (.vdir + '\Reports\Welcome' +.vsfullname + '.pdf')
*(File setup for Student Handbook)
SET VAR vreport = ('\Reports\StudentHandbook.pdf')
SET VAR vfile2 = ((CVAL('currdir')) + .vreport)
*(Obtain School Name.)
SET VAR vschname TEXT = NULL
SET VAR v3 INTEGER = NULL
SELECT schoolname INTO vschname INDICATOR v3 FROM schoolinfotable
*(Establish all variables for the Print Routine)
SET VAR vpar1 = ('PDF|FILENAME' & .vfile1a)
SET VAR vpar2 = ('|EMAIL ON|EMAIL_TO_LIST' & .vstudentemail)
SET VAR vpar3 = +
('|EMAIL_FROM_NAME' & .vschname + '|EMAIL_FROM_ADDRESS' & .vschoolemail)
SET VAR vpar4 = '|EMAIL_SUBJECT Welcome to AFOL BI'
SET VAR vpar5 = +
'|EMAIL_BODY TEST Attached is your Welcome Letter and Student Handbook'
SET VAR vpar6 = ('|EMAIL_BCC_LIST' & .vschoolemail)
SET VAR vpar7 = +
('|EMAIL_SHOW_DIALOG off||ATTACHMENTS' & .vfile1a + '#' + .vfile2)
*(The above line is where I am having problems)
*(It will work using only the .vfile1a but will not send both the .vfile1a
and .vfile2. So far I can only get it send file .vfile1a)
SET VAR vpar8 = '|EMAIL_DELETE_AFTER_SEND off'
SET VAR vparameters1 = (.vpar1 + .vpar2 + .vpar3 + .vpar4 + .vpar5 + .vpar6+ +
.vpar7 + .vpar8)
PRINT newstudentreport WHERE studentid = .vstudentid +
OPTION PDF|FILENAME &vparameters1
Any help would be appreciated.
Thanks
Gary
