nomadforme.blogg.se - How to make merge fileds in word for labels

#How to make merge fileds in word for labels how to
#How to make merge fileds in word for labels mac os
#How to make merge fileds in word for labels code
#How to make merge fileds in word for labels series
#How to make merge fileds in word for labels windows

So we’ve got the label type selected and we have the data, let’s tell Mail Merge what data fields from the list to use for the label.Ĩ. If you have a specific range you wish to select enter it in the Cell Range text box, click OK to proceed. Select the sheet that contains the address list data from the Excel workbook. You will see the following prompt, click OK to continue.ħ. When the dialog box opens select the pre-formatted Excel spreadsheet containing the address list and click Open.Ħ. Note: This is where you can choose a FileMaker database, Apple Address book, or Office Address book as a data source.ĥ. Click Get List and select Open Data Source from the list.

Now that we have the correct label selected we will need to select the data source for the names and addresses that will be printed on the labels, expand the Select Recipients List section in the Mail Merge Manager to continue.Ĥ. Verify that the label dimensions are correct and click OK. Make sure to select the company and label number.ģ. Select the Label product company from the list, in this example I used Avery label number 5161. Click the Create New button to select Labels from the list.Ģ. In the Mail Merge Manager window click on Select Document Type to expand the selection. In this case we will be printing labels, but you can also print form letters, envelopes, and catalog.ġ. Click Mail Merge Manager from the list.įirst thing we need to do is select the document type that you will be printing. Create a blank document in Word 2011 and click Tools.Ģ.

#How to make merge fileds in word for labels how to

How to Print Labels in Word 2011 with Mail Merge Manager Open Mail Merge Manager in Word 2011ġ.

#How to make merge fileds in word for labels code

Try to keep data fields like Address, City, State, and Zip Code in separate columns (see example below).

#How to make merge fileds in word for labels mac os

Software/Hardware used: Excel 2011 and Word 2011 running on Mac OS X.īefore proceeding the first thing you need to do is ensure that you have a properly formatted Excel spreadsheet to use as the data source for your labels. If you have any comments or questions please use the comments form at the end of the guide.

#How to make merge fileds in word for labels windows

For those of your coming from Office for Windows you will notice that there a lot of differences between Mail Merge in Windows and Mac, but I’ve detailed each of the steps below to guide through the entire process. In the steps below I will show you how to print labels from a list using Word 2011.

I am unsure why the condition for printing the comma is true.Īs a workaround, you could create a query that combines city and state with a comma into a string that can be printed unconditionally.Are you trying to print a set of labels from an address list stored in Excel, FileMaker, or your Apple Contact list? If so you are going to love this guide. This also happens after the last real record so that the “empty” labels have a record number that is one higher than the last real label’s number. I see that the labels that do not have an address, do get a conditional comma.Īpparently, the labels wizard adds Next record to the end of each label to make LibreOffice progress to the next record. When you now select the rows that you want to print labels for from the Data source view and click Data to fields, the labels are filled with database data.

Click Syncronize Labels in the floating window.

In the Then box, type a comma and space and leave the Else box blank.

This condition results in TRUE when State is non-empty in the current record.

Click the Functions tab, and then click “Conditional text” in the Type list.

In the document, place the cursor between the two fields, and then return to the Fields dialog.

In the Database selection box, double-click an address book, click “City”, and then click Insert.

In the Type list, click “Mail merge fields”.

Choose Insert - Fields - Other, and then click the Database tab.

Create the document by clicking New Document.

On the Options tab, make sure the checkbox Synchronize contents is checked.

Leave the inscription empty, but make sure the checkbox Address is checked.

Choose File - New - Labels and choose the type of labels etc.

#How to make merge fileds in word for labels series

In your example of ", " between city and state you could adapt the first series of steps to apply them to a labels document like so: What you are looking for is Conditional text, as explained on the LibreOffice wiki page Defining Conditions in the section about conditional text based on the contents of a database field.