Afterward, select Envelope options from the Change Document layout.After that, select document type as Envelope > from Step 1 of 6 and click on Next: Starting document.Next, we will see a Mail Merge dialog box at the right corner of the Word document. After that, we will go to the Mailings tab > from Start Mail Merge > select Step by Step Mail Merge Wizard.In this method, we will use the Step by Step Mail Merger Wizard from the Mailings tab of the Word document to mail merge from Excel to Word Envelopes. Use of “Step-by-Step Mail Merge Wizard” Option to Mail Merge from Excel to Word Envelopes Read More: Mail Merge in Excel without Word (2 Suitable Ways)Ģ. Afterward, click OK to print mail merge from Excel to Word envelopes.Make sure All are selected as Print records. Afterward, from Finish & Merge > select Print Document.Ī Merge to Printer dialog box will appear.Afterward, you can click on the rightward arrow marked with a Red color box to see the preview of other recipient addresses as well.After that, we will click on Preview Results to see the preview.Here, you can see in the Delivery address box of the Envelope, the inserted recipient address. After that, press ENTER to go to the next line, and in the next line, we will select other options from the Insert Merge Fields list.In the same way, we inserted Last Name from the Insert Merge Fields list.You can see the inserted First Name in the DeliveryDeivery address box of the Envelope. After that, we will select First Name from that list.Next, you can see all the recipients address list options in your Excel file in that list. Here, we have to click on the drop-down arrow of the Insert Merge Field option.Now, apart from Address Blocks to create mail merge from Excel to Word envelopes, there is an Insert Merge Field option to insert the Delivery address in the Envelope. Therefore, we have created mail merge from Excel to Word Envelopes. You can click on the rightward arrow marked with a Red color box to see the address of other recipients as well.After that, to see the preview of the address from Preview Results > select Preview Results.Later, you will see the address of the first recipient in the Envelope. We can see the other addresses by clicking on the rightward arrow marked with a Red color box. Here, we will see the address of the first recipient in the preview box. After that, we will select the Address Block option from the Write and Insert Fields.Īn Insert Address Block dialog box will appear.Make sure the First row of data contains column header is marked. Then, we will select our Excel file named Mail Merge from Excel to Word Envelopes > click Open.Afterward, we will navigate to our Excel file.After that, we will go to the Mailings tab > from Select Recipients > select Use an Existing List.Now, we will select our Excel file for the address recipients list. Next, we will see the Delivery address box in the Envelope.
After that, we will click on the Envelope to insert the Delivery address box.Then, we will click on the top left corner to write the Return address.Next, you will see an Envelope has been created. Afterward, we click OK on the Envelope Options dialog box.Next, an Envelope Return Address dialog box will appear.
Afterward, we click on the Font of the Return address.Here, we keep the Font color, Underline style, and Effects as it is.You can select Font color, and Underline style by clicking on the drop-down arrow.Īlong with that, you can choose an Effects. After that, we select Bold as Font style > 14 as Font size.An Envelope Address dialog box will appear. Then, we click on the Font of the Delivery address. Here, we keep the Envelope size as it is.After that, you can change the envelope size by clicking on the drop-down arrow of the Envelope size box. After that, we will go to the Mailings tab > from Start Mail Merge > select Envelopes.Īn Envelope Options dialog box will appear.In this method, we will use the Envelope option from the Mailings tab of the Word document to mail merge from Excel to Word Envelope. Using Envelope Option to Mail Merge from Excel to Word Envelopes You can use any available Excel version.ġ. To do the task, we will use 2 different methods.
We will use this table to mail merge from Excel to Word Envelopes.
#Mail merge for envelopes code#
The following table has First Name, Last Name, Street Address, City, and Zip Code columns. Mail merge helps to create a group of envelopes for each address, where every individual envelope carries an address on our mailing list.Ģ Methods to Mail Merge from Excel to Word Envelopes In that case, mail merge acts like a handy feature. For many purposes, we have to send a bunch of mails to people with different addresses.
0 kommentar(er)
