This wikiHow teaches you how to use the 'Mail Merge' feature in Microsoft Word. Mail Merge allows you to use a spreadsheet of contact information to assign automatically a different address, name, or other piece of information to each copy of a document. You can access the mail merge field codes and add switches to them during the mail merge setup. 1 Open a new document in Word and select 'Tools,' 'Letters and Mailings' and 'Mail Merge' from the toolbar. The last piece of this three-part article is about merging your custom Word documents with your client list (exported from Outlook to Excel) for distribution. Explains how to selectively choose certain fields for exporting to Excel and explains how to customize, manage, and maintain that contact list in Excel. Step 1: Start the Mail Merge Wizard 1. Open an existing document in Word or type a new custom letter. ![]() From the Mailings tab, click Start Mail Merge, then select Step-by-Step Mail Merge Wizard from the dropdown menu. A Mail Merge window opens on the right side of the screen. Step 2: Select a starting document 1. The first window prompts to select a document type: Letters, Email Messages, Envelopes, Labels, Directory. Click each option on the list to view descriptions. For this exercise, choose Letters. Click Next to continue, then choose one of these three options: Use Current Document, Start from a Template, or Start from Existing Document. When finished, click Next to continue. JD Sartain Figure1—Step 2: Select starting document. Step 3: Select your recipients 1. The next window prompts you to select recipients. You can: Use an Existing List, Select from Outlook Contacts, or Type a New List. Since we added custom fields to our database and expect to add more in the future, we’re using an existing list from our Excel database. Click the first option, then click Browse. We have detected that you are using an Ad-blocker plugin. Anyone using an Ad-blocker plugin will be forced to wait 180 seconds instead of 10 on the 'please wait' page. Sims 2 woohoo with anyone mod. We would ask that you whitelist us and allow ads to show. This means our main source of income to cover bandwidth costs is blocked when you are using our free service. Select your database from the Select Data Source dialog window, click Open, then choose the applicable table from the Select Table dialog window, Click OK. NOTE: Confused? Excel files open on Sheet1 with additional tabs for Sheet2 and Sheet3. Excel calls these tables. When we saved the imported CSV file in Excel (as an.xlsx file), Excel used the filename (5-15-15 Contact List.xlsx) for the first tab (or table). So, choose the table called 5-15-15 Contact List. Word displays the selected database in the Mail Merge Recipients window. As indicated by the instructions, use the options in the bottom panel to make changes and/or refine your database before you merge it with your document. When finished, click OK. Then click Next to continue. JD Sartain Figure2—Step 3: Select recipients. Step 4: Insert an address block 1. The traditional letter format includes the date, contact information for both sender and receiver, plus a greeting. In our example, the sender’s contact information is printed on the corporate letterhead, followed by the date. To insert the recipient’s contact info, position your cursor two lines below the date and select Address Block from the Write Your Letter window pane. The Insert Address Block dialog opens with options for how the address block is displayed on this document. Check the boxes that apply and select a name format from the list. Notice the Preview pane on the right displays how your Address Block will appear on your letter. If the Postal Address is checked, but not displayed in the Preview pane on the right, click the Match Fields button to help Word find the missing fields. JD Sartain Figure3—Step 4 - Insert Address Block 4. The Match Fields dialog opens. The field names in the left column are the default names for these fields. Notice that over half of the field boxes say “not matched.” Click the down arrow on the right to display the field names used in your Excel database. For example, click the “not matched” field box arrow beside the line that says Address1. Select your field bStreet, and Word replaces the words “not matched” with bStreet. Repeat this same procedure for City, State, Postal Code, and Country, then click OK. Word takes you back to the Insert Address Block dialog. Verify that the complete address now displays in the Preview pane, then click OK. Word places the field called > on the second line beneath the date. JD Sartain Figure4—Step 4 - Verify address block 7. Move your cursor down two lines from the Address Block. Click Greeting Line in the Mail Merge window pane. The Insert Greeting Line dialog opens. Select a salutation from the dropdown list under Greeting Line Format. Next, choose a format for the recipient’s name. Next, choose a salutation for recipients with invalid or missing names. Use the arrows under the sample to browse and/or verify that the records are accurate. If any of the fields are missing or inaccurate, click the Match Fields button and follow the instructions above to make repairs. When finished, click OK. JD Sartain Figure5—Step 4 - Insert a greeting line 10. The next option on this menu is Electronic Postage. Choose this option if you have the Electronic Postage software and an account set up to use this feature.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |