Jump to content
  • 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

    • So #BIBA for Real is back! Anyone else going?    Handy Tip - "Speak to more people you don't know, than those you do know"   You can thank me later - with flowers 🌻 💖
    • "Warning re Sanctions Checks on #OpenGI"   This post is now available in the Public area of the Forum for review and comment 
    • Great to meet back up with the Open GI User Group Committee after soooooo many sessions on remote links   Breaking bread face to face is much more pleasant than a cup-of-soup in between video chats    Exciting times ahead for members and lot's of new stuff coming from Open GI
    • So - what is the point of this ..   Don't tell me even if you say "Yes" - it's actually being ignored?   Why would anyone restrict Sanctions Checks to specific Client / types - let alone specific Capture Page Layouts - SURELY a Yes/No per Client / Contact - and the existing global parameters - covers all the bases. Oh and where in the manual did it not explain this?   Either way - the Yes/No below is at best misleading for operators and at worst - a breach for the business!! Who's picking up that cost ...  
    • So, we find ourselves in modern day unprecedented time.  Governments around the world are applying strict sanctions against Russian companies and individuals and it's being made very clear that action will be taken if those sactions are ignored.   For most of us, this will not be an issue but what if you do have a sanctioned individual or company?  Are you checking?  Are you relying on Open GI Sanctions checking?   First of all, have you got Broker and Prospect Amendment completed under sanctions checking to review Commercial Risks?  Using the Level 1 Contacts on a Commercial master frame will also Sanction check whoever or whatever you put in for review.     However, what about your personal lines clients?  The client level is checked sure, but what about the contacts you've added??  Well, if you're not aware, be aware.  They don't get checked.  So, if you've corrected added a contact for a joint policyholder on a Home policy for example, just hope you've either got them insured in their own right somewhere or that they are not called Abramovich!     The point of Sanctions checking is that you have a record of the checks, in the event of something being highlighted.  Open GI have gone to the trouble of making this work for the Commercial risks but not Personal Lines.   However, your User Group Committee have raised this issue and will continue to apply pressure until something is done.
  • Create New...