I don’t think this is an RBase problem but I can’t figure this out. I want to use the code below to send reminders by Email and Text message. The code below works for Text message with MAPImail2 but fails with no errors using MAPImail4. The var looks like this 'vResult|To:[email protected].........
If I use the same code and use an email it works for MAPImail 2 and 4, the var looks like 'vResult|To:[email protected]........... SELECT custnum,apttime,fname,patemail,cll_phone,txtemail + INTO vcustnum INDICATOR vi1, vapttime INDICATOR vi1, vfname + INDICATOR vi1, vpatemail INDICATOR vi1 ,vcll_phone + INDICATOR vi1, vtxtemail INDICATOR vi1 FROM txtapt + WHERE custnum = .cust# SET VAR vbody TEXT = ('Please call if you can not make it' ) SET VAR vparameters = (.vquote +'vResult' +.vpipe + + 'To:'+ .vcll_phone + .vtxtemail + .vpipe + + 'Subject:'+ .vdrname & .vsubject & (CTXT(.vaptdate)) & (CTXT + (.vapttime)) + .vpipe + 'Body: '+.vbody + .vquote) PLUGINS mapimail2.rbl &vparameters pause PLUGINS mapimail4.rbl &vparameters Any suggestions? Marc
