When I hear "mail merge," I usually think of personalizing letters and printing envelopes. However, many other projects can make use of mail merge. This year I tackled a new Christmas gift project by using mail merge in OpenOffice.org (OOo) to create a tear-off daily calendar, personalized with holidays and family events. Here's how.
I started with OOo Calc, the spreadsheet portion of the suite. In the first row I put two column labels: DATE and EVENT. Under DATE I put the starting date for the calendar: 1/1/08. I then selected the cell, clicked on the black box in the lower right corner, and dragged downward until I saw the ending date that I wanted.