Note: You can get label templates from several online resources including the WorldLabel templates here.
OpenOffice.org 2.0 is out, but I wanted to make sure that everyone out there in OpenOffice.org 1.x land knows how to do mail merges. Everyone isn't going to be converting to OpenOffice.org 2.0 the day it comes out, so I hope this information will be useful for quite a few people for a while.
Mail merges are things like sending a holiday newsletter to everyone in your address book, with the same content but addressed to Dear Bob, Dear Mary, and so on. Mail merges also apply to envelopes and labels, since you might also want to print one envelope with the address for Bob on Main Street, Mary on Elm, and so on.
The procedure for doing mail merges isn't hard...it's just not obvious.
I'm posting the mail merge procedures from my GetOpenOffice.org Comprehensive Writer workbook, as well as the lab files that you need to do the exercises.
Enjoy! It's easy when you know how.
Click here get the procedure PDF document. Download mailmerge.pdf
Click here to get the spreadsheetM document you can use as the data for the mail merge. Download spreadsheetM.sxc
why won't my "tables" populate when I'm trying to create labels from databases?
Posted by: Patty | November 25, 2008 at 11:55 AM
Hi Patty,
The database likes to just do one thing at a time -- view the data and make labels out of it, or open the database and add stuff to it. If you're viewing the database, close it and any document referencing the DB before you add to the spreadsheet containing the data.
Posted by: Solveig | November 25, 2008 at 12:00 PM
Hello
How do you suppress blank lines when printing labels?
Posted by: Nigel | June 24, 2010 at 02:55 AM
Hi Nigel,
Unfortunately that's a bit complicated. Not horrible, but involved. See this post.http://openoffice.blogs.com/openoffice/2007/05/suppressing_bla.html
Posted by: Solveig | July 05, 2010 at 01:14 PM