![]() However, Microsoft Outlook also offers an option to create a mailing box just by importing a certain data type file (i.e., CSVfile type).Īs we have a data file of customers’ contact in Excel, we just convert the file in CSV format using Excel’s Save As feature. In the previous method, we used Microsoft Word to create a mailing list. Method 2: Creating a Mailing List Using the Microsoft Outlook Import Feature How to Make a Numbered List in Excel (8 Methods).Create a Unique List in Excel Based on Criteria (9 Methods).How to Generate List Based on Criteria in Excel (4 Methods).Read More: How to Make a Comma Separated List in Excel (5 Methods) You can pick a range of customer numbers to send the Email to. Type an appropriate subject (i.e., Address Change) in the Subject Line command box. ![]() Select Email Address in the To command box. Step 12: The Merge to E-mail dialog box appears. Step 11: You can Edit, Print, or even Email the letter just by clicking on the specific options (i.e., Send Email Message). Click on the direction arrows to move forward and backward among data. Simply Put a Space after the First Name as done in the below image.Īll the names of the customers will have similar space between their First and Last Names. You see no space between the First and Last Name of the customer. In a moment, the template transforms into the 1 st customer’s mailing letter as shown in the following picture. Just Select the Preview Results option (from the Preview Results section). Step 10:If you want to see the preview for any customer. The template will be similar as depicted in the picture below. The preview of your actions is displayed under the Preview section in the dialog box.Įxecuting Steps 1 to 9 prepares a template of the mail list for each customer in the data file. 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. Sample Dataset for Creating a Mailing List.xlsxĢ Easy Ways for Creating a Mailing List in Excel Method 1: Creating a Mailing List in Excel Using Microsoft Word Mail Merge
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |