{"id":390,"date":"2022-12-01T20:32:58","date_gmt":"2022-12-01T20:32:58","guid":{"rendered":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/access-and-mail-merge\/"},"modified":"2022-12-01T20:32:58","modified_gmt":"2022-12-01T20:32:58","slug":"access-and-mail-merge","status":"publish","type":"chapter","link":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/chapter\/access-and-mail-merge\/","title":{"raw":"Access and Mail Merge","rendered":"Access and Mail Merge"},"content":{"raw":"\n<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n \t<li>Create Word mail merge file from Access Data<\/li>\n<\/ul>\n<\/div>\nMicrosoft makes it easy to use data from one program and integrate it into another. One of the best ways to use Access with Word is in a mail merge. Here is how to have Access and Word work together to create mail merged letters to go out to customers.\n<div class=\"textbox tryit\">\n<h3>PRactice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/6cd9aacf-e9dd-4dce-92b0-dbdaf60ce57b\n\n<\/div>\n<ol>\n \t<li style=\"font-weight: 400;\">The first step is to open the customer contact database in Access you wish to use in the mail merger.<\/li>\n \t<li style=\"font-weight: 400;\">Open <strong>Access<\/strong>, and you will see the list of available sources in the navigation pane on the left, if not press F11 and the left navigation pane opens showing the contact table. Double click to open it.\n<img class=\"alignnone wp-image-4007 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192107\/Module_15_Access_MailMerge.1.png\" alt=\"Access screenshot of customer database table.\" width=\"1056\" height=\"657\"><\/li>\n \t<li style=\"font-weight: 400;\">Look through the table or query to identify the addresses to use in the mail merge for Word.\n<ol>\n \t<li style=\"font-weight: 400;\">If the addresses are saved in various tables, first create a simple select query with the fields needed, then select the query for the mail merge.<\/li>\n \t<li style=\"font-weight: 400;\">Make sure to check the data for errors or missing cells and correct it before starting the mail merge.<\/li>\n<\/ol>\n<\/li>\n \t<li style=\"font-weight: 400;\">Select the <strong>External Data<\/strong> tab, and in the <strong>Export<\/strong> group select the <strong>Word Merge<\/strong> button.\n<img class=\"alignnone wp-image-4008 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192144\/Module_15_Access_MailMerge.2.png\" alt=\"Access screenshot of external data tab, Word merge button.\" width=\"591\" height=\"164\"><\/li>\n \t<li style=\"font-weight: 400;\">A Word Mail Merge Wizard window then opens.\n<img class=\"alignnone wp-image-4009 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192205\/Module_15_Access_MailMerge.3.png\" alt=\"Access screenshot of customer database table import wizard screen.\" width=\"1057\" height=\"659\"><\/li>\n \t<li style=\"font-weight: 400;\">Decide if the wizard should like the address data into a new blank Word document or into an existing document. Select the option and click <strong>OK<\/strong>. For this example, we\u2019ll create a new document.<\/li>\n \t<li style=\"font-weight: 400;\">A Word documents opens, and the <strong>Mailings<\/strong> tab and <strong>Mail Merge<\/strong> pane are now open.\n<img class=\"alignnone wp-image-4010 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192233\/Module_15_Access_MailMerge.4.png\" alt=\"Word screenshot of mail merge document with mail merge wizard open.\" width=\"1018\" height=\"913\"><\/li>\n \t<li style=\"font-weight: 400;\">In the mail merge pane at the bottom are the wizard steps to walk through using the Next or Previous links. In Step 2 you can choose to compose your own letter or to pick from various templates. We\u2019ll choose a template and then update it. Click the link to move to the next step.\n<img class=\"alignnone wp-image-4011\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192310\/Module_15_Access_MailMerge.5.png\" alt=\"Word screenshot of mail merge document with mail merge wizard open and choosing letter template window open.\" width=\"504\" height=\"450\"> <img class=\"alignnone wp-image-4012\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192316\/Module_15_Access_MailMerge.6.png\" alt=\"Word screenshot of mail merge document with mail merge letter open.\" width=\"499\" height=\"450\"><\/li>\n \t<li style=\"font-weight: 400;\">In Step 3, select the Access contact file. Select the <strong>Browse<\/strong> link under <strong>Use an existing list<\/strong> area and select the Access file.<img class=\"alignnone wp-image-4013\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192414\/Module_15_Access_MailMerge.7.png\" alt=\"Word screenshot of mail merge document with mail merge letter open and step 3 open.\" width=\"496\" height=\"300\"> <img class=\"alignnone wp-image-4014\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192420\/Module_15_Access_MailMerge.8.png\" alt=\"Word screenshot of mail merge document with mail merge letter open and browse window open to select Access table file.\" width=\"498\" height=\"300\"><\/li>\n \t<li style=\"font-weight: 400;\">If you need to edit the list select the <strong>Edit recipient list<\/strong> and sort, apply filters, find duplicates, remove contacts, etc. in the open dialog box. In this case we\u2019ll use all the contacts for the merge.\n<img class=\"alignnone wp-image-4015 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192516\/Module_15_Access_MailMerge.9.png\" alt=\"Word screenshot of mail merge recipients from Access table file.\" width=\"628\" height=\"462\"><\/li>\n \t<li style=\"font-weight: 400;\">Now is the time to in the Word document to edit the letter, select the area for the address data to appear and select the Address block, Greeting line, etc. in the right side Mail Merge wizard menu and it inserts the Access data into the document.\n<img class=\"alignnone wp-image-4016\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192553\/Module_15_Access_MailMerge.10.png\" alt=\"Word screenshot of mail merge document with mail merge letter open  and wizard option to place merge fields in document.\" width=\"580\" height=\"350\"> <img class=\"alignnone wp-image-4017\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192558\/Module_15_Access_MailMerge.11.png\" alt=\"Word screenshot of mail merge document with mail merge buttons highlighted in the Mailings tab.\" width=\"428\" height=\"350\">\n<ol style=\"list-style-type: lower-alpha;\">\n \t<li style=\"font-weight: 400;\">Besides using the Wizard, you can format each merging area from the Mailings tab, Write &amp; Insert Fields group in the ribbon.<\/li>\n \t<li style=\"font-weight: 400;\">Select the style of greeting, the formality or informality or other options in the dialog boxes for each merge field.\n<img class=\"alignnone wp-image-4018\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192709\/Module_15_Access_MailMerge.12.png\" alt=\"Word screenshot of mail merge  letter open and address merge field window open to select how address is displayed.\" width=\"551\" height=\"351\"> <img class=\"alignnone wp-image-4019\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192715\/Module_15_Access_MailMerge.13.png\" alt=\"Word screenshot of greeting line merge field window open to select how greeting is displayed.\" width=\"384\" height=\"299\"><\/li>\n<\/ol>\n<\/li>\n \t<li style=\"font-weight: 400;\">The wizard\u2019s step 5 allows you to preview the merged data in the document before you print it. Even in this stage you may have forgotten to add a space between the first and last name, too much space in the address field, or other errors. Now is the time to correct them.\n<ol style=\"list-style-type: lower-alpha;\">\n \t<li style=\"font-weight: 400;\">Use the <strong>Preview your letters<\/strong> area to arrow through the recipients and double check for errors.<\/li>\n \t<li style=\"font-weight: 400;\">If you decide at this point to exclude one or a few of the recipients click the Exclude this recipient button or click the Edit recipient list link.\n<img class=\"alignnone wp-image-4020 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192904\/Module_15_Access_MailMerge.14.png\" alt=\"Word screenshot of mail merge  letter open and area for arrowing through merged letters to check or exclude recipients.\" width=\"1006\" height=\"639\"><\/li>\n<\/ol>\n<\/li>\n \t<li style=\"font-weight: 400;\">Step 5 completes the merge and Step 6 of the wizard is where you Pint the merged document. There is an option at this step to change individual letters by selecting the Edit individual letters link which generates all the letters in one Word file so you can edit.\n<img class=\"alignnone wp-image-4021 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27193004\/Module_15_Access_MailMerge.15.png\" alt=\"Word screenshot of mail merge  letter ready to print and the print window open.\" width=\"795\" height=\"661\"><\/li>\n \t<li style=\"font-weight: 400;\">The last step is to save the new mail merged document for later printing or to send to someone else to print and send these letters.<\/li>\n<\/ol>\n<div class=\"textbox tryit\">\n<h3>PRactice Question<\/h3>\nhttps:\/\/assess.lumenlearning.com\/practice\/89f75668-a20d-4383-a681-ba5c83a0faff\n\n<\/div>\nNow that you have walked through the steps of merging and Access table into a Word mail merge letters here is a six minute video to watch and see the entire process to reinforce the steps.\n\n<iframe src=\"\/\/plugin.3playmedia.com\/show?mf=4369412&amp;p3sdk_version=1.10.1&amp;p=20361&amp;pt=375&amp;video_id=Knk03inA0k4&amp;video_target=tpm-plugin-erf9t4mz-Knk03inA0k4\" width=\"800px\" height=\"450px\" frameborder=\"0\" marginwidth=\"0px\" marginheight=\"0px\"><\/iframe>\n\nYou can also view a transcript for the video <a href=\"https:\/\/course-building.s3-us-west-2.amazonaws.com\/ComputerApps\/Transcripts\/MailMergeMicrosoftAccessDataIntoMicrosoftWordDocuments_Transcript.txt\" target=\"_blank\" rel=\"noopener\">\u201cMail Merge Microsoft Access Data into Microsoft Word Documents\u201d here (opens in new window)<\/a>.\n<h2>Contribute!<\/h2><div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div><a href=\"https:\/\/docs.google.com\/document\/d\/1ZZ6aDpPVfl6bW7PyoNKq9yH7-YLjwHPCOke2bkRojic\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a>\n","rendered":"<div class=\"textbox learning-objectives\">\n<h3>Learning Outcomes<\/h3>\n<ul>\n<li>Create Word mail merge file from Access Data<\/li>\n<\/ul>\n<\/div>\n<p>Microsoft makes it easy to use data from one program and integrate it into another. One of the best ways to use Access with Word is in a mail merge. Here is how to have Access and Word work together to create mail merged letters to go out to customers.<\/p>\n<div class=\"textbox tryit\">\n<h3>PRactice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_6cd9aacf-e9dd-4dce-92b0-dbdaf60ce57b\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/6cd9aacf-e9dd-4dce-92b0-dbdaf60ce57b?iframe_resize_id=assessment_practice_id_6cd9aacf-e9dd-4dce-92b0-dbdaf60ce57b\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<ol>\n<li style=\"font-weight: 400;\">The first step is to open the customer contact database in Access you wish to use in the mail merger.<\/li>\n<li style=\"font-weight: 400;\">Open <strong>Access<\/strong>, and you will see the list of available sources in the navigation pane on the left, if not press F11 and the left navigation pane opens showing the contact table. Double click to open it.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4007 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192107\/Module_15_Access_MailMerge.1.png\" alt=\"Access screenshot of customer database table.\" width=\"1056\" height=\"657\" \/><\/li>\n<li style=\"font-weight: 400;\">Look through the table or query to identify the addresses to use in the mail merge for Word.\n<ol>\n<li style=\"font-weight: 400;\">If the addresses are saved in various tables, first create a simple select query with the fields needed, then select the query for the mail merge.<\/li>\n<li style=\"font-weight: 400;\">Make sure to check the data for errors or missing cells and correct it before starting the mail merge.<\/li>\n<\/ol>\n<\/li>\n<li style=\"font-weight: 400;\">Select the <strong>External Data<\/strong> tab, and in the <strong>Export<\/strong> group select the <strong>Word Merge<\/strong> button.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4008 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192144\/Module_15_Access_MailMerge.2.png\" alt=\"Access screenshot of external data tab, Word merge button.\" width=\"591\" height=\"164\" \/><\/li>\n<li style=\"font-weight: 400;\">A Word Mail Merge Wizard window then opens.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4009 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192205\/Module_15_Access_MailMerge.3.png\" alt=\"Access screenshot of customer database table import wizard screen.\" width=\"1057\" height=\"659\" \/><\/li>\n<li style=\"font-weight: 400;\">Decide if the wizard should like the address data into a new blank Word document or into an existing document. Select the option and click <strong>OK<\/strong>. For this example, we\u2019ll create a new document.<\/li>\n<li style=\"font-weight: 400;\">A Word documents opens, and the <strong>Mailings<\/strong> tab and <strong>Mail Merge<\/strong> pane are now open.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4010 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192233\/Module_15_Access_MailMerge.4.png\" alt=\"Word screenshot of mail merge document with mail merge wizard open.\" width=\"1018\" height=\"913\" \/><\/li>\n<li style=\"font-weight: 400;\">In the mail merge pane at the bottom are the wizard steps to walk through using the Next or Previous links. In Step 2 you can choose to compose your own letter or to pick from various templates. We\u2019ll choose a template and then update it. Click the link to move to the next step.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4011\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192310\/Module_15_Access_MailMerge.5.png\" alt=\"Word screenshot of mail merge document with mail merge wizard open and choosing letter template window open.\" width=\"504\" height=\"450\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4012\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192316\/Module_15_Access_MailMerge.6.png\" alt=\"Word screenshot of mail merge document with mail merge letter open.\" width=\"499\" height=\"450\" \/><\/li>\n<li style=\"font-weight: 400;\">In Step 3, select the Access contact file. Select the <strong>Browse<\/strong> link under <strong>Use an existing list<\/strong> area and select the Access file.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4013\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192414\/Module_15_Access_MailMerge.7.png\" alt=\"Word screenshot of mail merge document with mail merge letter open and step 3 open.\" width=\"496\" height=\"300\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4014\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192420\/Module_15_Access_MailMerge.8.png\" alt=\"Word screenshot of mail merge document with mail merge letter open and browse window open to select Access table file.\" width=\"498\" height=\"300\" \/><\/li>\n<li style=\"font-weight: 400;\">If you need to edit the list select the <strong>Edit recipient list<\/strong> and sort, apply filters, find duplicates, remove contacts, etc. in the open dialog box. In this case we\u2019ll use all the contacts for the merge.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4015 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192516\/Module_15_Access_MailMerge.9.png\" alt=\"Word screenshot of mail merge recipients from Access table file.\" width=\"628\" height=\"462\" \/><\/li>\n<li style=\"font-weight: 400;\">Now is the time to in the Word document to edit the letter, select the area for the address data to appear and select the Address block, Greeting line, etc. in the right side Mail Merge wizard menu and it inserts the Access data into the document.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4016\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192553\/Module_15_Access_MailMerge.10.png\" alt=\"Word screenshot of mail merge document with mail merge letter open  and wizard option to place merge fields in document.\" width=\"580\" height=\"350\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4017\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192558\/Module_15_Access_MailMerge.11.png\" alt=\"Word screenshot of mail merge document with mail merge buttons highlighted in the Mailings tab.\" width=\"428\" height=\"350\" \/><\/p>\n<ol style=\"list-style-type: lower-alpha;\">\n<li style=\"font-weight: 400;\">Besides using the Wizard, you can format each merging area from the Mailings tab, Write &amp; Insert Fields group in the ribbon.<\/li>\n<li style=\"font-weight: 400;\">Select the style of greeting, the formality or informality or other options in the dialog boxes for each merge field.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4018\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192709\/Module_15_Access_MailMerge.12.png\" alt=\"Word screenshot of mail merge  letter open and address merge field window open to select how address is displayed.\" width=\"551\" height=\"351\" \/> <img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4019\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192715\/Module_15_Access_MailMerge.13.png\" alt=\"Word screenshot of greeting line merge field window open to select how greeting is displayed.\" width=\"384\" height=\"299\" \/><\/li>\n<\/ol>\n<\/li>\n<li style=\"font-weight: 400;\">The wizard\u2019s step 5 allows you to preview the merged data in the document before you print it. Even in this stage you may have forgotten to add a space between the first and last name, too much space in the address field, or other errors. Now is the time to correct them.\n<ol style=\"list-style-type: lower-alpha;\">\n<li style=\"font-weight: 400;\">Use the <strong>Preview your letters<\/strong> area to arrow through the recipients and double check for errors.<\/li>\n<li style=\"font-weight: 400;\">If you decide at this point to exclude one or a few of the recipients click the Exclude this recipient button or click the Edit recipient list link.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4020 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27192904\/Module_15_Access_MailMerge.14.png\" alt=\"Word screenshot of mail merge  letter open and area for arrowing through merged letters to check or exclude recipients.\" width=\"1006\" height=\"639\" \/><\/li>\n<\/ol>\n<\/li>\n<li style=\"font-weight: 400;\">Step 5 completes the merge and Step 6 of the wizard is where you Pint the merged document. There is an option at this step to change individual letters by selecting the Edit individual letters link which generates all the letters in one Word file so you can edit.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4021 size-full\" src=\"https:\/\/s3-us-west-2.amazonaws.com\/courses-images\/wp-content\/uploads\/sites\/3008\/2020\/01\/27193004\/Module_15_Access_MailMerge.15.png\" alt=\"Word screenshot of mail merge  letter ready to print and the print window open.\" width=\"795\" height=\"661\" \/><\/li>\n<li style=\"font-weight: 400;\">The last step is to save the new mail merged document for later printing or to send to someone else to print and send these letters.<\/li>\n<\/ol>\n<div class=\"textbox tryit\">\n<h3>PRactice Question<\/h3>\n<p>\t<iframe id=\"assessment_practice_89f75668-a20d-4383-a681-ba5c83a0faff\" class=\"resizable\" src=\"https:\/\/assess.lumenlearning.com\/practice\/89f75668-a20d-4383-a681-ba5c83a0faff?iframe_resize_id=assessment_practice_id_89f75668-a20d-4383-a681-ba5c83a0faff\" frameborder=\"0\" style=\"border:none;width:100%;height:100%;min-height:300px;\"><br \/>\n\t<\/iframe><\/p>\n<\/div>\n<p>Now that you have walked through the steps of merging and Access table into a Word mail merge letters here is a six minute video to watch and see the entire process to reinforce the steps.<\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/plugin.3playmedia.com\/show?mf=4369412&amp;p3sdk_version=1.10.1&amp;p=20361&amp;pt=375&amp;video_id=Knk03inA0k4&amp;video_target=tpm-plugin-erf9t4mz-Knk03inA0k4\" width=\"800px\" height=\"450px\" frameborder=\"0\" marginwidth=\"0px\" marginheight=\"0px\"><\/iframe><\/p>\n<p>You can also view a transcript for the video <a href=\"https:\/\/course-building.s3-us-west-2.amazonaws.com\/ComputerApps\/Transcripts\/MailMergeMicrosoftAccessDataIntoMicrosoftWordDocuments_Transcript.txt\" target=\"_blank\" rel=\"noopener\">\u201cMail Merge Microsoft Access Data into Microsoft Word Documents\u201d here (opens in new window)<\/a>.<\/p>\n<h2>Contribute!<\/h2>\n<div style=\"margin-bottom: 8px;\">Did you have an idea for improving this content? We\u2019d love your input.<\/div>\n<p><a href=\"https:\/\/docs.google.com\/document\/d\/1ZZ6aDpPVfl6bW7PyoNKq9yH7-YLjwHPCOke2bkRojic\" target=\"_blank\" style=\"font-size: 10pt; font-weight: 600; color: #077fab; text-decoration: none; border: 2px solid #077fab; border-radius: 7px; padding: 5px 25px; text-align: center; cursor: pointer; line-height: 1.5em;\">Improve this page<\/a><a style=\"margin-left: 16px;\" target=\"_blank\" href=\"https:\/\/docs.google.com\/document\/d\/1vy-T6DtTF-BbMfpVEI7VP_R7w2A4anzYZLXR8Pk4Fu4\">Learn More<\/a><\/p>\n\n\t\t\t <section class=\"citations-section\" role=\"contentinfo\">\n\t\t\t <h3>Candela Citations<\/h3>\n\t\t\t\t\t <div>\n\t\t\t\t\t\t <div id=\"citation-list-390\">\n\t\t\t\t\t\t\t <div class=\"licensing\"><div class=\"license-attribution-dropdown-subheading\">CC licensed content, Original<\/div><ul class=\"citation-list\"><li>Access and Mail Merge. <strong>Authored by<\/strong>: Sherri Pendleton. <strong>Provided by<\/strong>: Lumen Learning. <strong>License<\/strong>: <em><a target=\"_blank\" rel=\"license\" href=\"https:\/\/creativecommons.org\/licenses\/by\/4.0\/\">CC BY: Attribution<\/a><\/em><\/li><\/ul><div class=\"license-attribution-dropdown-subheading\">All rights reserved content<\/div><ul class=\"citation-list\"><li>Mail Merge Access to Microsoft Word. <strong>Authored by<\/strong>: PC Learning Zone.com. <strong>Located at<\/strong>: <a target=\"_blank\" href=\"https:\/\/www.youtube.com\/watch?v=Knk03inA0k4\">https:\/\/www.youtube.com\/watch?v=Knk03inA0k4<\/a>. <strong>License<\/strong>: <em>All Rights Reserved<\/em>. <strong>License Terms<\/strong>: Standard YouTube License<\/li><\/ul><\/div>\n\t\t\t\t\t\t <\/div>\n\t\t\t\t\t <\/div>\n\t\t\t <\/section>","protected":false},"author":503070,"menu_order":11,"template":"","meta":{"_candela_citation":"[{\"type\":\"original\",\"description\":\"Access and Mail Merge\",\"author\":\"Sherri Pendleton\",\"organization\":\"Lumen Learning\",\"url\":\"\",\"project\":\"\",\"license\":\"cc-by\",\"license_terms\":\"\"},{\"type\":\"copyrighted_video\",\"description\":\"Mail Merge Access to Microsoft Word\",\"author\":\"PC Learning Zone.com\",\"organization\":\"\",\"url\":\"https:\/\/www.youtube.com\/watch?v=Knk03inA0k4\",\"project\":\"\",\"license\":\"arr\",\"license_terms\":\"Standard YouTube License\"}]","CANDELA_OUTCOMES_GUID":"54ae2d4a-9b29-4bed-b6c4-9618d0d6493d, 07985079-4d40-4e3d-81bf-8b361f5a190e","pb_show_title":"on","pb_short_title":"","pb_subtitle":"","pb_authors":[],"pb_section_license":""},"chapter-type":[],"contributor":[],"license":[],"class_list":["post-390","chapter","type-chapter","status-publish","hentry"],"part":379,"_links":{"self":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters"}],"about":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/types\/chapter"}],"author":[{"embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/users\/503070"}],"version-history":[{"count":0,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/390\/revisions"}],"part":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/parts\/379"}],"metadata":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapters\/390\/metadata\/"}],"wp:attachment":[{"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/media?parent=390"}],"wp:term":[{"taxonomy":"chapter-type","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/pressbooks\/v2\/chapter-type?post=390"},{"taxonomy":"contributor","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/contributor?post=390"},{"taxonomy":"license","embeddable":true,"href":"https:\/\/courses.lumenlearning.com\/suny-compappmgr\/wp-json\/wp\/v2\/license?post=390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}