Merge Letter Version 5.5.14

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
bill327
Posts: 18
Joined: Wed Dec 26, 2007 6:45 pm
Location: Hollsopple, Pa

Merge Letter Version 5.5.14

Post by bill327 »

Has anyone else seen this issue? Merge letters gives an unhandled exception error while switching to word. I didn't have this problem in version 5.5.11.
Bill MacWilliams
Kapricorn Systems Inc.
Service Manager/Programmer
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Post by jordansparks »

The only time I've seen it is if the version of Word is wrong.
Jordan Sparks, DMD
http://www.opendental.com
User avatar
bill327
Posts: 18
Joined: Wed Dec 26, 2007 6:45 pm
Location: Hollsopple, Pa

We over thought the problem.

Post by bill327 »

We over thought the problem on this. Thanks for getting us back on track.
Bill MacWilliams
Kapricorn Systems Inc.
Service Manager/Programmer
fishdrzig
Posts: 433
Joined: Tue Oct 07, 2008 12:46 pm

Re: Merge Letter Version 5.5.14

Post by fishdrzig »

Does the letter Merge feature work with OpenOffice or still with Word only?
User avatar
jordansparks
Site Admin
Posts: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Merge Letter Version 5.5.14

Post by jordansparks »

Still just with Word.
Jordan Sparks, DMD
http://www.opendental.com
User avatar
drtech
Posts: 1668
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: Merge Letter Version 5.5.14

Post by drtech »

I have moved to all Open Office b/c if costs an arm and a leg to have MS Office on all my computers. If we could get the merge to work with open office that would be great. Open Office 3 works great. It opens much faster than before (which was it's major drawback)
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com
lennox
Posts: 14
Joined: Sat Oct 06, 2007 8:31 am

Re: Merge Letter Version 5.5.14

Post by lennox »

Drtech,

I've written a small interface between OD and OO Writer. My wife just started using it at her practice, and it seems to work well. It is not extensively tested (installed for 1 wk now). Presently, it saves the file to the images directory and inserts it into the database, from which you can doubleclick it and have it open in OpenOffice. There is also an option to save it to an external file. It looks for templates (any .odt file) ONLY in the images root directory for now. I may change this to look at alternate locations in the future, but a fixed location makes installation a bit easier on multiple machines (just look for the directory location from the database).

It has only been tested on Vista, and not extensively. However, I'd be willing to e-mail you a copy (it's only 100k in size presently). No guarantees that it will work, but I'd be pleased to have somewhat else test drive it briefly to see how well it works outside of our practice, and get suggestions from another user as to what would make it more useful/user friendly.

Note: It doesn't use the letter merge feature. Instead, it links "keywords" to replacement searches. For example, you could set {{PATIENTNAME}} to a database select that would result in "Lname, Fname, MI", or "Mr(s) Lname Fname", or the address, etc. My wife is not very technical, so not having to define fields was much easier for her. She can type the codeword as regular text.

I have not posted this anywhere, but if I clean it up a bit, I may.

Let me know if you are interested, and how to get it to you.

Lennox
User avatar
drtech
Posts: 1668
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: Merge Letter Version 5.5.14

Post by drtech »

sure, I would be happy to test it out....i will send you a private message with my e-mail
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com
Post Reply