Figure 3: Printed version of labels with variable addresses (Think how much goofier if you had three address lines in your database.) See figure 3. And, while the post office certainly will deliver letters and packages addressed like this, it does look kind of goofy. However, this is how your labels will look when they come out of the printer. If there is no value for the Address2 field, you leave it blank.įigure 2 shows what the labels template looks like when you set up your mail merge. You create your database and, for each person, fill in the Firstname, Lastname, Address1, Address2, City, State, and Zip fields as appropriate.

This is reflected, of course, in the database. Some have a second line for the address some don’t. You’ll need all the relevant information for their addresses to print out on labels, or in the header of form letters. So why is this worth mentioning? Because it affects how you do mail merges when you send mail to these people. Some work in enormous campuses with mailstops or buildings in the address others receive their work mail at a post office box.Įveryone knows this, of course. Some people live in houses some in apartments.

If you’re already familiar with the problem, you can go straight to the solution entitled: Suppressing blank lines with sections step by step. This article solves that perpetual problem with labels. There’s only one problem-all records aren’t created equal they don’t all have, or all need, the same fields. Mail merges are a great way to save time, since they pull information from the same fields, over and over again with each new record in your database.

Openoffice conditional formatting