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: 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!
#WORD MAC 2011 HOW TO MAIL MERGE LABELS FROM EXCEL 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. For more info, see Set up a mail merge list with Word.You put so much thought into your perfect invitation. Word data file is a data source you can create on the fly, within Word. See Use Outlook contacts as a data source for a mail merge Outlook Contact List contains data in a format that can be read by Word. For more info, see Prepare your data source in Excel for a mail merge in Word for Mac. Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process.Įxcel spreadsheet works well as a data source if all data is on one sheet and the data is formatted so that it can be read by Word. Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. This type of document is also called a catalog merge.Ĭreate a directory of names, addresses, and other information Use it to print out your contact list, or to list groups of information, like all of the students in each class. You'll be sending the email directly from Word.Įnvelopes or Labels where names and addresses come from your data source.Ĭreate and print a batch of envelopes for mailingĬreate and print sheets of mailing labelsĭirectory that lists a batch of information for each item in your data source. Each letter prints on a separate sheet of paper.Ĭreate and print a batch of personalized lettersĮmail where each recipient's address is the only address on the To line. Letters that include a personalized greeting. Follow the links for details about each type: Word provides tools for incorporating your data into the following kinds of documents. Use Outlook contacts as a data source for a mail merge If you know you'll be using Excel or Outlook as the source of your data, see: If you don't yet have a data source, you can even type it up in Word, as part of the mail merge process.įor details about data sources, see Data sources you can use for a mail merge. Excel spreadsheets and Outlook contact lists are the most common data sources, but any database that you can connect to Word will work.
0 kommentar(er)
