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 post

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 post
  • 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 post
  • 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 post

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

    • Hour and a half for us. Microsoft's Hyper-V doesn't leverage host CPUs very well at all.
    • If you want to know who won this year in each category, follow the link below   Insurance Times - Tech & Innovation Awards - 2020
    • EXTENDED OFFER   Even though "lock-down" has almost been confined to the history books, there's still lots of uncertainty across the UK   Restrictions and limitations are impacting businesses every day and worse still, the uncertainty looks continue for a while yet   Whether you need more knowledge or just better insight, at OneFiftyPercent we want to help as many Open GI brokers as we can    If you want to re-boot your business or take away current system pains there is no better time than the "now"   For help with any aspect of your OGI systems or associated applications, just get in touch with us and book your FREE call     Guaranteed 150% - No strings. No Fees. No catch.   Leave your preferred contact details at the link here and we'll be in touch   #karma #network #freehelp #OFP #resultsdontlie
    • I don’t believe so as very specific criteria has to be set each time a purge is ran (at least in Live). Purging also has separate stages e.g. you have to purge ledger & diary before an actual policy/client record can be removed.   For all I know there may be an overnight command for Prospect to purge quotes/prospects ‘marked for deletion’, however we review these first as anyone can press Esc K (and maybe doing so for the wrong reasons).   Bottom Line, I feel nervous purging when doing manually, I would not like the idea of records disappearing from the system each night etc.  Sorry, I’ve not been much help!
    • Hi I know there is a module in OGI for record purging is there any way that this can be automated does anyone know?. I am keen to have any information about this.    Regards Mar
  • Create New...