You can put Comma ( ,) or other delimiters after the Recipient Name. From the Insert Greeting Line dialog box, Step 9: The Insert greeting Line dialog box pops up. After that Hover to the Write & Insert Fields section > Select Greeting Line. Step 8: Again, Place the cursor in front of the greeting line (i.e., Dear Recipient Name). You can insert any of the fields in your message, Then, select any of the fields (i.e., First Name) afterward, Click on Insert as shown in the image below.Īfterward, repeat Step 7 about 3 or 4 times to insert First Name, Last Name, Company Name, City, State, and Zip Code. Select the Database Fields under the Insert section. Step 7: The Insert Merge Field dialog box appears. Place the cursor beside the Recipient Name then Go to Insert Merge Field (in the Write & Insert Fields under the Mailings tab). Make sure you check the First row of data contains column headers toggle. Select the required file (i.e., Creating a Mailing List in Excel). Step 4: Selecting the Use an Existing List takes you to your computer folders. Step 3: Select the Select Recipients (from Start Mail Merge section) > Choose the Use an Existing List (from the options). The Blue colored writing will be in accordance with the mailing list you are about to create. Step 2:Write down the message according to your requirements (i.e., informing the customer about Address Change). Open Microsoft Word, Go to the Mailings tab > Select Letters (from S tart Mail Merge section). Step 1: As you want to create a mailing list, you have to prepare a written message using Microsoft Word. The Mail Merge will automatically insert a mailing list after we execute the following sequences. The data holds all the customers’ Names, Company Names, Company Addresses, and Email Addresses. We can use the feature to create a template of a mailing list after importing the data from Excel. Microsoft Word offers a feature named Mail Merge.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |