[RBASE-L] - Re: email attachments

[Jim Belisle]

Thanks Jan.  

 

Jim

 

________________________________

From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of jan
johansen
Sent: Wednesday, November 26, 2008 8:01 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: email attachments

 

Jim, 

Make sure you have a subfolder called PDF. 

Change vfilename to 

SET VAR vfilename = ('PDF\SalesQuote_'+.vquoteid+'.PDF') 


 Jan 

         

        -----Original Message----- 
        From: "Jim Belisle" <[EMAIL PROTECTED]> 
        To: rbase-l@rbase.com (RBASE-L Mailing List) 
        Date: Wed, 26 Nov 2008 07:36:40 -0600 
        Subject: [RBASE-L] - email attachments 

        When I decide to email a quote to my potential customer, the
quote is automatically saved to my current directory which I like.  I
want it to be saved to a specific file folder however and it escapes me
where I would put that file into the command.  Below is the command used
to create the file.  Would I put the folder name in the SET VAR
vattachments variable?  

        SET VAR vfilename = ('SalesQuote_'+.vquoteid+'.PDF') 

        PRINT kayparkquote WHERE quoteid = .vquoteid + 

        OPTION PDF + 

        |FILENAME &vFileName + 

        |TITLE Kay Park Recreation + 

        |SUBJECT Sales Quote + 

        |AUTHORIZATION Sales Quote Processing Department 

        -- Prepare Required Parameters for MAPIMail3.RBL Plugin to Send
E-Mail 

        SET VAR vquote = (CVAL('QUOTES')) 

        SET VAR vpipe = '|' 

        SELECT distid INTO vdistid INDICATOR ivdistid FROM quoteheader +


        WHERE quoteid = .vquoteid 

        SELECT distemail INTO vto INDICATOR ivto FROM quoteheader WHERE
quoteid = .vquoteid 

        SET VAR vto = ('To:'+.vto) 

        SET VAR vsubject = ('Subject:Sales Quote'&.vquoteid) 

        SET VAR vcc = 'Cc:[EMAIL PROTECTED]' 

        SET VAR vbcc TEXT = 'Bcc:[EMAIL PROTECTED]' 

        SET VAR vbody TEXT = + 

        'Body:Please review attached sales quote. Thanks!' 

        SET VAR vattachments =
('Attachments:'+(CVAL('CURRDIR'))+'\'+.vfilename) 

        SET VAR vsenddirect = 'SendDirect:TRUE' 

        SET VAR vparameters = + 

        
(.vquote+.vdummy&.vpipe+.vto&.vpipe+.vsubject&.vpipe+.vcc&.vpipe+.vbcc&.
vpipe+.vbody + 

        &+.vpipe+.vattachments&.vpipe+.vsenddirect) 

        CLS 

        PLUGINS mapimail3.rbl &vparameters 

        Jim