![mail merge mac pages mail merge mac pages](http://www.macosxtips.co.uk/index_files/numbers-spreadsheet.png)
On step 5 in the Mail Merge wizard, click the > button to preview the names and how they will appear on the envelopes.
![mail merge mac pages mail merge mac pages](https://spherelasopa750.weebly.com/uploads/1/2/6/2/126227196/543074977.png)
(I find it easier to do this first in the original Excel file.) 3. Optional: From there you can do “Filter Recipients” if you want to filter anyone on the list out. You may have to move the text box so it is centered appropriately on the envelope template. Placeholder fields will populate based on how you named your header rows, such as > Drag each field into your text box and arrange the way you want placed on your envelope. Alternatively, you can just include all data. Choose the data range that you want to include (which may just be the tab, if you have multiple tabs) and press OK. Select your Excel file from your computer. Select Recipient List > Open Data Source. Do NOT change the orientation of the page or it can cause your envelopes to print sideways! A4, A6), you can add a custom size and enter the envelope measurements yourself. If the preset envelope size isn’t there (e.g. Select Document Type: select “Envelope” and set the size. Go to Tools > Mail Merge Manager and from the pop-up window, follow the steps:
![mail merge mac pages mail merge mac pages](https://images.squarespace-cdn.com/content/v1/5189cd2ce4b01dba4e6a80e3/1382060472743-A9HC6B21NRLOU0ENLCXZ/ke17ZwdGBToddI8pDm48kPl-QFS7g2a1rsEH6iUg6kkUqsxRUqqbr1mOJYKfIPR7LoDQ9mXPOjoJoqy81S2I8N_N4V1vUb5AoIIIbLZhVYy7Mythp_T-mtop-vrsUOmeInPi9iDjx9w8K4ZfjXt2dm1CQT03VfKrGl4ngNp7TlAobdNYBEciswuzR3NTe3TkCjLISwBs8eEdxAxTptZAUg/1.png)
Open Microsoft Word and create a new blank document. (For example, “123 Main Street” should be a separate cell from “New York, NY 10000” so that you can separate them on separate lines later.) So you will likely have these columns:ī) Address (you can also have an Address 2 column if you have a lot of people with long addresses) & Mrs.”) and has each address line separated out into different columns. Be sure it is formatted in a way that includes the appropriate salutation (e.g. You likely have a typed out list already of your guests and their addresses. If you notice any differences, please post helpful tips in the comments!
MAIL MERGE MAC PAGES FOR MAC
Note: I am using Microsoft Office 2011 for Mac so my steps may not align exactly with your version of Word. We created this handy step-by-step guide for doing a mail merge from your spreadsheet of guests into envelopes or mailing labels. We navigated through the tricky process of turning your guest list into printed envelopes. Unless you have the budget to hire a calligrapher (or in many cases, only using a calligrapher for the invitations, not the save the date) the only options here are to handwrite each one, print on mailing labels (which many people do), or print directly onto the envelope (which looks much more professional). But now you actually have to address them. You asked the post office for the cutest wedding-themed stamps. You picked matching envelopes and have the perfect return address label. You found the perfect designer to create them (hopefully us!) and the final product came out beautifully. You put so much thought into your perfect invitation.