I want to print serial numbers from a LO Calc spreadsheet onto half-sheet labels (2 labels per 8.5 x 11 sheet). Each label is 5.5" x 8.5".
After not finding a template for my Avery 5126 labels, I am using the LO Avery letter size 5315 (Laser Note Cards) template. It is specified as 5.5" x 8.5" (2 x 1) in LO. That’s exactly what I need (see note below).
I think I have done all the steps correctly. The first sheet is printed correctly. However, all following sheets change orientation (to portrait) and what is printed on the page is scaled differently (consequently I cannot read all the text for the 2nd document on each sheet so it is hard to tell if my database info is printing correctly).
I do not know whether I am making a mistake or I have encountered a bug. I’m relatively new to LO Mail Merge. Very confusing…
I am running LO 5.0.1 on Kubuntu 12.04 and 14.04. I am using HP Linux Imaging and Printing (HPLIP) version 3.15.9 (which was the most current version about a month ago).
UPDATE: This issue does not happen if I print to file. So a workaround may be to do the Mail Merge and print to a single file, then print that file to the printer. This does indeed work. But I do not feel it is practical. I can only imagine all the problems my employees will have if I recommend this method. The support costs would be tremendous.