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.
Mailings 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)
