Pick the range of data source records to use, then click OK and you get the regular print options window. (Another approach is to choose File → New → Text Document, create a new Writer document, select View → Data Sources (or press F4 ) and drag the fields you want onto the document.) It will let you pick the data source you want to use. Choose File → Wizards → Letter and work through the wizard.You must have Base installed for this wizard to be available. To do this, choose File → Wizards → Address Data Source from the menu bar and follow the wizard's pages. First you need to "register" the data source (spreadsheet, address book, other file, or database) that the mail merge will use.Mail Merge is ready to produce your envelopes.There are three main steps: creating the data source, creating the mail merge document, and printing. If all looks good, click Next: Complete the merge. You can use the little arrow buttons to navigate through the list to see how other records appear. The preview envelope is now displaying the actual names and addresses from our database, exactly as they'll appear when they're mailed out. You'll notice that «AddressBlock» is now displayed on the envelope where the address will appear.Ĭlick Next: Preview your envelopes to continue. The dialog box has closed and we're now back at the Arrange your envelope step. You'll also notice that Insert postal address is now selected. Use the little arrows to step through the list if you need to. Now the envelope preview is displaying an address from our list.Ĭheck that it appears in the correct format. If you find yourself in a similar situation, and you plan to do more mail merges in the future, you may wish to check Remember this matching for this set of data sources on this computer to save you from having to manually match the fields each time.Ĭlick OK once you've matched the fields you need. Therefore, by deselecting that option at the previous step, the wizard is less restrictive and we can continue by matching some of the optional fields. Had we selected Insert recipient's name and Insert postal address at the previous dialog box, there would be many more required fields - some of which we don't have matching fields in our database. We can use CustomerName from our database for this field (our database only has one field for the customer name). In this example, there's only one required field ( Company). Use the drop-down list to select a field from your database that matches the field on the left. Use this dialog box to match the fields that appear on the envelope, with the fields from your database. However, if the envelope preview is blank (like in this example), you will need to match the fields. Use this dialog box to determine how the fields will be displayed on the envelope.ĭepending on how your database has been designed, you may be able to select Insert recipient's name in this format and Insert postal address. However, Word recognizes that we're already using a table from Access, so Use an existing list is now selected, with the details listed below.Ĭheck that it looks correct and click Next: Arrange your envelope to continue.Ĭlick on the envelope where the address block should go. This is where you get to select the recipients. The envelope is now displayed in relative proportions to the size that you selected.Ĭheck that it looks correct and click Next: Select recipients to continue. The Use the current document is now selected. to launch the Envelope Options dialog box. Select Change document layout then click Envelope options. Select the Envelope Size and other Options.So select Envelopes from the Mail Merge wizard at the right of the screen. Select the document type that you'd like to work on.įor this example, we're doing a mail merge so that we can put names and addresses on envelopes. Select whether you want to link the data to an existing document or create a new document.įor this example, we'll create a new document from scratch.Ĭlick Create a new document and then link the data to it.Īt this point, Microsoft Word should be open and blinking in the Taskbar.Ĭlick on the Microsoft Word button in the Taskbar to open Word. Select the table or query that contains the list of names and addresses.Ĭlick Word Merge in the Import & Link group from the External Data tab on the Ribbon. In the following example, we'll walk through the process of setting up envelopes with names and addresses, so that they're ready for printing and mailing. Combine Access 2016 with Word to address envelopes to a list of people.Ī mail merge lets you address envelopes to all individuals in a table or query.
0 Comments
Leave a Reply. |