Jump to content
Why are we here ..... ×
  • 0

Keywords into Email



Following the Open GI User training, we have put our renewal letter into Tables, all works fine on word letters.

However when we pull the template into Email, all is working other than the renewal premium

the code we are currently using for the calculation is btx.orig.debt     

the annual premium which is a bpy is working in the email.    

your help would be appreciated

KR   Lesley and Kate   from Meadons Insurance Brokers

Link to comment

4 answers to this question

Recommended Posts

  • 0

Hi Lesley - hope you are well


Have you tried using the BLT alternatives?


Always tricky on which should be used (BTX/BLT) - and depends on when / where the letter (mail) request is initiated. But if it's OK in a letter - it should be OK in the mail - you would like to think ... 


The on-line guides confusingly use both types in the examples - but I cant find the recommended options / reasons / guidelines which are documented in there somewhere!


Try BLT options but if not, come back and I'll have another look on the systems and get you a definitive answer - if I can :)


Otherwise Marc PB - the maestro of OpenWord - may need to jump in 


Let me now 




Link to comment
  • 0

Thanks Mark and hi there Lesley and Kate


My first question is where is the e-mail being initiated from?


If it's anywhere other than the Transaction itself, the BTX and BLT related original debt won't work properly because it needs to know which one it's looking for.


Obviously, this does make it a pain when trying to attach Renewal Schedules from OpenPrintManager.  I'm looking into ways around it.  I'll keep you posted.

  • Like 1
Link to comment
  • 0
On ‎18‎/‎11‎/‎2017 at 23:24, karl said:

Pretty sure I had this issue when letters not printed directly from transaction and resolved it with code selecting BTX records. Will check Monday and feedback.

Yeah, I just looked and I created a back office doc with a Calculations box in it containing:-


select btx find last where


[BTX.Trantype] eq "r"


[YCT.Date2] is [BTX.Dt.raised]

[YCT.Var1.2] is [BTX.orig.debt]


Then just include as text document within your OpenWord template and set the YCT variable as needed to display latest renewal transaction info.


  • Like 1
Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Posts

    • Hi Claire,   We took on INVU back in 2008 and still use it today in its Virtual Cabinet guise. No issues with printing from VC whether that be to network printers or pdf and there are also options to send from VC to email which can be useful.    Overall, we remain very happy with VC so have seen no real advantage to move over to OpenAttach.   One little issue is we never managed to get the automatic indexing / filing of standard OGI/OpenWord letters and emails into VC. We just click a few buttons to file them manually.   Happy to chat through further if you wish - I will be at the Members day this coming Thursday    Darren
    • Hi @Clare Carter   I probably cant advise on day to day use / issues, but may be able to help although not sure of your question   Are you still on Virtual Cabinet (VC) and how are you trying to print on OGI - and what / where from   Also - I'm pretty sure there are minimal issues with transferring to OpenAttach - what are the concerns there?  
    • Just wondering if any of the current members have previously been using Virtual Cabinet, and which originally was Invu provided by Linden House.   It is only relatively recently that Open GI have come up with Open Attach but there is an issue in transferring data.   If anyone is still using Virtual Cabinet which evolved from Invu and Linden House, could they let me know whether they had any issues with Open GI and printing.    Thanks
    • Hi Andrew   I do have a copy - but you can get them / best to get latest copy from the support site - presumably you have a registered account??   Just go to the link here RMAR Reports and Spreadsheet   Any problems come back and let me know!
    • Hi   I am new to OGi and not sure how the system deals with the FCA required Client Money Calculation. A previous post mentioned a OGI PDF document detailing the reports to get the numbers and apparently there is a spreadsheet to input all the numbers as well.   Is anyone able to forward the PDF and spreadsheet or provide assistance please.   Thanks
  • Create New...