Some examples of data sourcesare Microsoft Word tables, Microsoft Outlook contact list, Microsoft Excel worksheet, MicrosoftAccess database, or text files.Finished Documents consist of: Merged main documents and data sources that create yourfinal products (i.e. The data will bethe parts of the document that varies (names, addresses, etc.). Forexample, in a form letter, the address blockand greeting name would be unique in eachcopy.The Data Source consists of: Files or tables thatcontain the data (information) that you will use tomerge data into a merge document. Placeholders for unique information. You only have to type thisinformation once regardless of how many lettersyou intend to print. In any mail merge, you'll deal with threedifferent elements: Main Document – form letter, mailing label, envelope, or directory(a single document that stores addresses)Data Source – information such as names and addressesFinished Documents – mail merge documents that can serve as templates for futuremailings.The Main Document consists of: Information that isidentical in each copy, such as the main body textof a form letter.You can use mail merge in Office 2016 to create form letters or address labels, certificates with. Click on the Mailings tab.Copyright 2006 ASCPL 12:57:03 PM/DM of 14Mail merge lets you easily turn one document into several personalized, unique versions of it. Then we will try it with the buttons on the ribbon.To get started creating letters: Open a New Blank word document. First we will walk through the wizard. Thereis a wizard which can assist with the mail merge process, or you can use the buttons on theribbon. They can then be used as templates for yourfuture mail merge needs.Mail Merge WizardIn Microsoft Word 2016, there are two different ways to complete the Mail Merge process.
![]() To show the mail merge wizard, click Start Mail merge and choose Step by Step Mail Merge Wizard (Outlook 2007/2010) to use the wizard pane.Click on the Start Mail Merge button.Click Step by Step Mail Merge Wizard.The wizard will open in the task pane to the right.The letters radio button is already selected in the task pane. Click the Update Labels button to copy the fields to all labels. Insert the merge fields you need. Using the Mail Merge Feature in Microsoft Word 2016 for Mac. You can choose an existing list, use yourOutlook mail contacts*, or type a new list.(*If your Outlook mail is not configured, then you will not beable to use this option.) Choose Use an existing list and click on Browse Copyright 2006 ASCPL 12:57:03 PM/DM of 14Choose Properties and then click on the Advanced system settings link. Then click on Next: Select recipients from thebottom of the task pane.(Note: You can always go backwards by clicking on thePrevious links.) You will then be prompted to select your mail mergerecipients. Select theMailMergeLetter.doc from the Mail Merge folder inthe Documents folder. For class, select the Startfrom existing document and the start from existing documents option will becomeavailable. You can choose a document you currently have displayed in the main Word window,start from a template, or choose an existing document file. You can use an Exceldocument, an Access table, or a listcreated in Word (which we will coverlater). Choose your list from its locationon your computer. This app allows you to realize really personalized mass mailing easily and efficiently by providing a set of requested and unique features:The Select Data Source window willopen. Mail Merge Toolkit is a powerful add-in for Microsoft Office extending the mail merging capabilities in Microsoft Outlook, Microsoft Word and Microsoft Publisher. Outlook 2016 Mailmerge How To Create YourownThe Mail Merge Recipients window willopen, asking which people on your listyou wish to include in this mailing.Uncheck anyone you want to exclude.Then click on OK to close the dialogbox. Make sure you are on the correctsheet and click on OK. (If youwould like to know how to create yourown Excel address list at home, see Appendix A.) Because we opened an access database, sometimes a dialog box will appear that willask which worksheet tab the information is located on. Once we get to the next step you will see actual names andaddresses in that space. After you click OK, you will see a place holder on the page that says«Address Block». The Insert Address Block window will open and you can choose the format of thename and address. Then click on Address Block from the task pane to theright.Copyright 2006 ASCPL 12:57:03 PM/DM of 14Mail Merge Toolkit is a powerful add-in for Microsoft Office 2019, 2016, 2013, 2010, 2007, 20 (XP) designed to extend the mail merging capabilities in Microsoft Outlook, Microsoft Word. Click on an empty spot of your document where you would like therecipient’s address to appear. Now we are going to insert the address block,greeting line, first name, donation amount andorganization. Be sure to have the appropriate spaces before andafter your entries.Copyright 2006 ASCPL 12:57:03 PM/DM of 14Once the appropriate fields have been added to your letter it will resemble the examplebelow: Then click on the Next: Preview your letters link at thebottom of the task pane.Once the recipient fields have been set you can thenpreview your letter with the fields populated. Replace the question marks withFirst Name, Donation Amount and Organization.Highlight each question mark (?) and change it to theappropriate field. The More Items field allows you to insert additionalfields or match fields from an existing database orspreadsheet file. If you don’t like the optionsthey have given you, you can always type yourown greeting in the box that says “Dear” andyour own punctuation in the appropriate box.Then click OK.You will see a place holder that says«Greeting Line». Select the format for the nameand the greeting. Click on Greeting line from the task paneon the right. Click on Sort Choose what column you want to sort by.o For class, choose Zip Code. You can add ordelete fields and change the order inwhich they appear.When you are done creating/editing your address list, click on the OK button.Give your list a name and click on Save.To edit your list in the future, click on the Edit Recipient List button once it has beenselected as the list to use for that document.Copyright 2006 ASCPL 12:57:03 PM/DM of 14In the window that opens, click on the name of the list from the box in the lower leftcorner then click on the Edit button.Sorting Click the Edit Recipient List form the Start Mail Merge group. See the next page for creating a list usingMicrosoft Word.To get started creating a Data Source within Mail Merge Click the Select Recipients button and then onType New List Enter the information for yourrecipients across the row and clickNew Entry to proceed to the nextrecipient.By selecting Customize Columns you can add fields relevant to yourrecipients like spouse’s name orsuffix.The Customize Address List dialogbox will appear. If you want to include areturn address on your envelope, type it in the upper-left corner of the document.Now we need to choose a recipient list. Once you have finished previewing your letters you mustclick on the Next: Complete the merge link at the bottomof the task pane.Copyright 2006 ASCPL 12:57:03 PM/DM of 14The last step allows you to either print your letters or edit individual letters as needed.NOTE: For class the entries are red but when printing you will want tochange the font color to match the rest of your letter.To get started creating envelopes: Click on the New button on the Quick AccessToolbar or open a blank word document under File,New.Click on the Mailings tab.Click on the Start Mail Merge button and selectEnvelopes In the Envelope Options dialog box, select theoptions you want, such as envelope size, font size,printer feed method, rotation, and printer tray feed.Then click OK.Copyright 2006 ASCPL 12:57:03 PM/DM of 14Your page will become the same dimensions as an envelope. Notice that the fields are populated with your recipients. Jpg to word converter for macOnce you have inserted the appropriate merge fields you must click on the PreviewResults button from the Ribbon. (Click around until you find it.) Make sure your cursor is blinking inside the text box and insertthe appropriate merge fields (Address block, Postal bar code, etc.) byclicking on the buttons in the ribbon or select individual fields just like youwant them to appear on the envelope from the Insert Merge Field button inthe Write and Insert Fields group. You will see a list of only recipients with the letter D in their first name.Click OK again to use these recipients only.Copyright 2006 ASCPL 12:57:03 PM/DM of 14Back to Envelopes Click in the center of the envelope towards the bottom and atext box will appear. Click on Filter Choose what column you want to sort by.o For class, choose First Name.o Choose containso Type D.o Click OK. You can modify thedimensions by clicking on the Details button.If you do not see your label number listed in the box,click on the New Label button. Select yourlabel brand and type from the list. From here you can print your envelopes by clicking on theFinish & Merge button and on Print Documents Insertyour envelopes into the printer the way you previouslyspecified.To get started creating labels: Click on the New button on the Quick Access Toolbar or open a blank word documentunder File, New.Click on the Mailings tab.Click on the Start Mail Merge button and selectLabels.The Label Options window will open. When creating your Mail Merge labels, documents, etc. Make sure you choosethe sheet labeled Adult Info.
0 Comments
Leave a Reply. |
AuthorShannon ArchivesCategories |