The columns in the spreadsheet match the fields you want to use in a mail merge.Your Excel sheet has one row for each recipient.If you want to add more details, you'd better do this before starting the merge.

When you run a mail merge, your Excel file will get connected to your Word document, and Microsoft Word will be pulling the recipient details directly from the connected worksheet.īefore running a mail merge in Word, make sure your Excel file has all the information you want to include such as first name, last name, salutation, zip codes, addresses, etc. Preparing Excel spreadsheet for mail merge The goal of the mail merge is to combine the data in File 1 and File 2 to create File 3.

The final Word document with personalized letters, emails, labels, or envelopes.

Word document with codes for the personalized fields.

Excel source file with information about the recipients such as names, addresses, emails, etc.

To get a grasp of the basics, you can think of it in terms of 3 documents. Now you don't have to waste time tweaking printer settings in Word or another office app - Whether you're printing at home or on the road, from your phone or using a Mac, Linux or Windows PC, a Google Chromebook or Android mobile device, Amazon Fire™ or Apple iPad™ tablet, you can print envelopes anywhere, free, with goEnvelope.A mail merge may look like a daunting task, but in fact the process is pretty simple. If you entered a recognized address, a POSTNET barcode will be added to your envelope. You can use standard PDF viewer controls to print or save the addressed envelope.

The Go to Envelope button will show a PDF of your addressed envelope. You can choose to save the address on your computer for later use by checking the box underneath.

Address and print envelopes without downloading templates or installing software Print envelopes from your phone, tablet, PC, Chromebook or any web device Create a PDF of your envelope and print it on your printerĮnter your address in the text box at top, and your recipient address in the one below.

Free envelope template word download