creating address labels in excel for mac

Creating Address Labels In Excel Free Pages Data
Creating Address Labels In Excel Movie On The

If you intend to email the results of your work, select the email address that appears in the list under step 1 and, from step 2s pop-up menu, choose Assign As Email Recipient Address.

Is there a way I can use the two of them to create mail merge documents.

There is, although its not a feature directly built into either app.

This is possible through the power of AppleScript (dont worry, Im not going to ask that you learn AppleScript in order to carry out this job).

Creating Address Labels In Excel Free Pages Data

Here youll find an AppleScript and Pages page that provides instructions for using the free Pages Data Merge utility (the page also includes a link to that utility).

As its name suggests it lets you incorporate data found in a Numbers spreadsheet into a Pages documents.

Creating Address Labels In Excel Movie On The

A movie on the page describes the process from beginning to end but I can give you the gist.

You start by creating a Pages document that serves as the template for your merged documents.

Feel free to insert real or fake names, addresses, phone numbers, email addresses, and so on for placeholder text.

If the Format pane isnt present, click the Format button in Pages toolbar and click the More tab.

Now select the first placeholder entry and from Pages Format menu choose Advanced Define As Placeholder Text.

A Script Tag field will appear in the Text pane to the right.

Into this field enter the name of your placeholderFIRSTNAME, ADDRESS, PHONE, MATENAME, or whatevers most appropriate.

Repeat for each bit of text that you wish to use as a placeholder.

You then launch Numbers and create a spreadsheet that includes columns for each entry.

The column header need not match the placeholder names youve created.) Now select all the rows that contain the data you want to merge.

In Numbers, create a spreadsheet that includes the data you want to merge.

Launch the Pages Data Merge app and walk through the numbered steps.

In the area marked with a 1, choose Selection of Numbers Table from the pop-up menu and click the Import button.

When you do, the information from the first column in the Numbers document will appear in the Data Record Items area.

Click on the pop-up menu next to the second step and youll see a list of all the placeholders youve created in the Pages document.

Select the one associated with the entry you highlighted in step 1 (in the example youd choose FIRSTNAME ).

When you make a selection in the second step, its name appears under the Assigned Placeholder Tags heading in the first step.

In step 5 you can choose to email a copy of your merged document to your recipients.

In order for this to work you must create a list of email addresses for your recipients in your Numbers document (having an email placeholder in the Pages document isnt necessary).

Creating Address Labels In Excel For Mac