Hi Bart I'm still trying to get a grip with this mail merge business. How do I add a field for firstname? Your example letter would suggest xxxfirstnamexxx,...
Les, I am just thinking that maybe it would be better to do away with the fixed combination xxxPatientxxx altogether and make any field like this: xxxField. ...
Will keep the xxxPatientxxx header for backwards compatibility, but will add the option to take xxxFIRSTNAME, xxxSURNAME etc. as well. That will give you all...
Les, Think got worked this out now. This is how it will be: ... ID fields should be left as they are, so don't put xxx in front. Non-ID fields should have xxx...
Fixed the mailmerge routine as suggested. There was in fact a bug due to the ID fields not having spaces anymore since adding the option to run SQL on sheet...
Bart Getting error with the linking routine. It can happen on launching or during adding codes. Run-time error '91' Object variable Or With block not set. ...
Paul, I could reproduce this error and understood precisely why it happened then I fixed it and that solved it for me and never saw it again. I just tried it...
Bart This is an old message that has taken two days to reach the list. I am now on 12.32 and working fine Paul ... From: ExcelReportingAddin@yahoogroups.com ...
Fixed a bug to do with the new address search in the ID page in combination with a single patient type search. Also added the post code to the single patient...
Martin, My Blueyonder e-mail has packed up again and not sure you got my reply to your question, so here a repeat: You will have to re-design your report and...
Fixing faulty DSN will now again work on a stand-alone (home) system. Filter on patients found by the last node didn't work properly when there were collection...
Is it pssoble to do a search, using the add in for parameters that the s6000 Report Manager refer to as eg "like .9i%" ? The example given would look for any...
Dan, Just put in 9i and it will find any Read code that starts with those 2 characters. Pressing the E button in front of the first Read code box will explain...
Excellent. Thanks. Dan Jeffery GP Stanley Surgery Wakefield ... From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com]On Behalf...
Hi Bart I've just downloaded this report, but cannot see how those with flu jab this season have been excluded - can you please explain? Cheers Les ... -- Les ...
Hi Les, It is not my report, but one made by Martin Rowlatt. I haven't looked into the clinical side of the report, just checked it did what the report asked...
Is there a bug with 12.34? A simple report with 1 Morbidity, say H333. Tick the "Show" boxes for Read Code, Term & Free Text and you get the extra columns as...
Hi Chris, You misunderstood how this works and this is actually explained in the new help file. Let me explain: What is used for the fields in the sheet are...