[RBASE-L] - Table structure

[jan johansen]

Group,

It's time for me to replace a very old table or at least revamp it.
I'm looking for ideas for a PARTS or INVENTORY table (or however you may 
call it).
Anyone willing to share their favorite .TBL file?

Jan

 


-----Original Message-----
From: "jan johansen" <j...@jjcalibrations.com>
To: rbase-l@rbase.com (RBASE-L Mailing List)
Date: Mon, 26 Sep 2011 09:54:58 -0700
Subject: [RBASE-L] - Re: Cannot use Multiple Addresses in 9.1 MapiMailPlugin


Bill,
 
I believe you are missing the dotted variable on you B
 
set v vMultiMailTo1 text=(.vMultiMailToA+';'+ vMultiMailToB)
 
Jan
 

 
-----Original Message-----
From: <beyr...@lampsoftware.com>
To: rbase-l@rbase.com (RBASE-L Mailing List)
Date: Mon, 26 Sep 2011 09:37:59 -0700
Subject: [RBASE-L] - Cannot use Multiple Addresses in 9.1 MapiMail Plugin


I am using rbg9.1-64 latest and pluginpowerpack 91.
 
I cannot get the mapimail3 plugin to launch with more than 1 name. Is there 
a limitation on the the number of addresses mapimail3 can send ?
 
Here is my code, can anyone spot an obvious error ?
 
clear all variables
set v vInsStart date=08/01/2011
set v vInsEnd date=12/31/2011
SET VAR vQuote TEXT = NULL
SET VAR vQuote = (CVAL('QUOTES'))
SET VAR vDummy TEXT = 'vDummy'
SET VAR vPipe TEXT = NULL
SET VAR vPipe = '|'
SET VAR vTo TEXT = NULL
SET VAR vSubject TEXT = NULL
SET VAR vCc TEXT = NULL
SET VAR vBcc TEXT = NULL
SET VAR vBody TEXT = NULL
SET VAR vAttachments TEXT = NULL
set v vMultiMailToA text='beyr...@lampsoftware.com'
set v vMultiMailToB text='beyr...@mhabermanassoc.com'
set v vMultiMailTo1 text=(.vMultiMailToA+';'+vMultiMailToB)
set v vMultiMailTo1=.vMultiMailTo1
SET VAR vQuote TEXT = NULL
SET VAR vQuote = (CVAL('QUOTES'))
SET VAR vDummy TEXT = ('vDummy')
SET VAR vPipe TEXT = NULL
SET VAR vPipe = ('|')
SET VAR vTo TEXT=('TO:'+.vMultiMailTo1)
SET VAR vperiod text=((ctxt(.vInsStart))+'To:'+(ctxt(.vInsEnd)))
SET VAR vSubject=('Subject:Inspection Report From:'+.vPeriod)
SET VAR vCc TEXT=('CC:')
SET VAR vBcc TEXT=('BCC:')
set v vBody2 text=('Please Review attached Inspection Report.')
SET VAR vBody TEXT=('BODY:'+.vBody2)
SET VAR vAttachments TEXT=('Attachments:'+.vfilespec)
set v vresolve text=('Resolve_Names:FALSE')
SET VAR vParameters TEXT = NULL
SET VAR vParameters = +
(.vQuote+.vDummy&.vPipe+.vTo&.vPipe+.vSubject&.vPipe+.vCc&.vPipe+ +
.vBcc&.vpipe+.vBody&+.vPipe+.vAttachments&.vPipe+.vresolve)
PLUGIN MapiMail3 &vparameters
ret
 
Thanks,
 
Bill Eyring