Access+Mail+Merge+lesson

Home / software / microsoft access / Tutorials

> > > Microsoft Word starts. > > > > > > Click Next: Starting Document > > > > > > > > > >
 * Practical Learning: Creating a Mail Merge ||
 * 1) Start Microsoft Word
 * 2) From the resources that accompany these lessons, open Promotion.docx
 * 3) Press Ctrl + A to select everything
 * 4) Press Ctrl + C to copy
 * 5) Close Microsoft Word and return to Microsoft Access
 * 6) From the resources that accompany these lessons, open the Bethesda Car Rental1 database
 * 7) In the Navigation Pane, in the Tables section, click Customers
 * 8) To start a mail merge, on the Ribbon, click External Data
 * 9) In the Export section, click Word Merge
 * 10) Click the second radio button:
 * 1) Click the second radio button:
 * 1) Click OK.
 * 1) In Microsoft Word, press Ctrl + V to paste the Promotion.docx document (this would be the equivalent of creating or designing the document)
 * 1) In the Mail Merge window, to create a letter to be sent out, accept the Letters radio button
 * 1) In the Select Starting Document section, make sure Use the Current Document is selected Click Next: Select Recipients
 * 1) Click Next: Write Your Letter
 * 1) In the Microsoft Word document, double-click Date and press Delete
 * 2) On the Ribbon of Microsoft Word, click Insert
 * 3) In the Text section, click Date & Time
 * 4) In the Available Formats list box of the Date & Time dialog box, click the second option (day, month, and year)
 * 1) Click OK
 * 2) Press Enter
 * 3) Click the right side of Dear
 * 4) In the Mail Merge window, click More Items
 * 5) In the Fields list, click FirstName
 * 1) Click Insert
 * 2) Click Close
 * 3) Press the Space bar
 * 4) In the Mail Merge window, click More Items...
 * 5) In the Fields name, double-click LastName
 * 6) Click Close
 * 7) In the Mail Merge window, click Next: Preview Your Letters
 * 1) In the Mail Merge window, click the next recipient button [[image:http://www.functionx.com/access/buttons/nextrec2.gif width="30" height="23" caption="Next Recipient"]] and observe the name in the document
 * 2) Click the next recipient button 4 times and observe the names in the document
 * 3) Click the previous recipient button 2 times and observe the names in the document
 * 4) In the Mail Merge window, click Next: Complete the Merge
 * 5) Close Microsoft Word
 * 6) When asked whether you want to save, click Save
 * 7) Set the file name as **Bethesda Car Rental Promotional Campaign1**
 * 8) Click Save