How To Print Envelopes From Excel

How To Print Envelopes From Excel – One of the best ways to improve your stationery is the thought and care you give when handling your envelopes. This is attention to detail at its highest level and, surprisingly, an often overlooked aspect. Hiring a calligrapher is top of mind for such a job, however, it is not always an option in the budget. Printing directly on your envelopes using a DIY template is another inexpensive way that will impress your guests with beautiful, elegant looking envelopes.

Of course, you want your beautiful envelopes to be accepted by your postal service, so you need to comply with the guidelines of your country. Without getting too technical, below are some general guidelines to follow:

How To Print Envelopes From Excel

• Do not place any words or art too close to the edge of the envelope, especially at the top or bottom right as this is usually where postal barcodes will go.

Printed 4 Bar Envelopes

• Recipient address must be addressed first. The return address can go in the upper left corner of the front or on the back of the envelope.

Whether you make your own template or buy one, it’s important to consider the envelope size you need and make sure your document is sized appropriately. For example, a 5×7 invitation is the size of an A7 envelope, which is 7.25 x 5.25 inches.

When choosing a template, you’ll want to consider what program you’re using and how comfortable you are working with that program. In this tutorial, I use one of my editable templates built in Corjl, which allows you to edit right in your web browser. Try the demo here.

In the video below, I’ll show you how to edit addresses and create a PDF that’s ready to print. You can try a demo of this template by clicking the link below.

How To Make An Envelope Template (or Snag Ours For Free)

Getting the settings and alignment right can be trial and error at first, so be sure to run a few test prints before sending the whole batch. For this reason, it is recommended to have 5-10 envelopes just in case, but you can also try printing on plain paper. I have found that placing the envelopes face down in the printer feed works best for correct alignment, with the side you will be printing on. However, your printer may be different than mine, so it’s important to run a few test prints until you get the settings right.

Open the PDF you downloaded and you are ready to print it (Ctrl + P or File – Print). This should bring up a dialog box to select your printer settings. Under “Page Setup” make sure your paper size matches the size of the envelope you will print. Always choose “No Scaling” or 100%.

Before you put your envelopes in the printer feeder, I highly recommend going over all the edges with a file, the edge of a ruler or even your fingernail to smooth down all the edges. It’s annoying, I know, but it really works wonders to prevent smudges when using the printer so it’s worth the effort. I also recommend adding an envelope page if possible to prevent bouncing.

With beautifully addressed envelopes in hand, you’re ready to send out your invitations in style. Need more inspiration? Check out the easy-to-use templates in my Etsy shop. Demo links are available individually in the descriptions.

How To Print On An Envelope In Microsoft Excel

To help you navigate the DIY process, I’ve put together a comprehensive PDF guide full of practical how-to tips and helpful tips. We’ll cover printing techniques, how to choose the right paper for your project, and my top 15 money-saving tips to help you stay on budget. To grab our free A7 envelope template for use in Microsoft Word, simply click here. To download the calligraphy font we used (you’ll need it to make your envelopes just like ours), scroll to the bottom of this post and follow the links.

I hate to say it, especially since I’ve been known to learn calligraphy a time or two, but hiring a professional calligrapher to do your wedding invitations is a waste of money. At $3+ for an envelope, why not put down your credit card and create an envelope template (or grab our free A7 envelope template!) that you can print at home. Make as many copies as you need, and repurpose the child in thank you notes, holiday cards, you name it.

Just follow this lesson and you will never give another envelope for as long as you live.

Although most word processing software gives you a “Convert” option, I’ve found that it’s often bulky and basic. While it’s great for business printing, it’s not what you want for wedding envelopes or fancy stationery.

How To Print Envelopes In Microsoft Word

Hopefully you’ve already figured this out, but you need to know how big your envelopes are (in inches or centimeters) with the flap closed. If you can’t find the information on the packaging, just get a ruler and measure.

For our invitations, we recommend 5.25″ x 7.25″ A7 envelopes but this may vary depending on the size of your invitations. If you don’t know what size envelopes you need, this handy chart can help you choose the right one.

Go to Page Layout > Size > Additional Paper Sizes. Enter the size of your envelope in the width and height fields and click OK.

Go to Insert > Text Box > Draw Text Box. Draw a text box in the center of your document, making sure to leave plenty of room for postage stamps and a return address at the top.

How To Print Envelopes Using Word From Data In Excel

To remove the black border around a text box, click the text box and go to Format > Border Shape > No Border.

Once you’ve added your first text box, just click on the outer edge so there’s a solid black line around it, and press Ctrl+C and Ctrl+V to duplicate it. I prefer to create one text box for each text style (ie calligraphy words get a box, while serif addresses get a separate box).

One of the reasons we don’t use the “Convert” functionality in Word is because this method allows us to use custom fonts, graphics, and layouts.

I think envelopes look best with a combination of calligraphy, sans serif and serif fonts. But that’s up to you. Ideally, you’ll want to choose 1-2 fonts that match your wedding invitations so that everything looks the same.

A7 Envelope Template

A note on return addresses: In this example I put the return address on the front of the envelope for convenience. If you would like to put it in the background, follow the same steps to create a

In a brand new document. When it’s time to print, you’ll print the front side of your envelopes first, then flip over and print the back side.

Once your template looks the way you like it, you’ll want to duplicate the pages to print several at once.

To draw your page, click on the gray border outside the page. This will highlight your text boxes.

How To Print Addresses On Envelopes

Inside the text box. You should see a blinking cursor in the upper left corner of the page. Hit end on your keyboard (this will add blank pages after the existing page).

Go to Insert > Blank Page. Click 15-20 times to add more pages. (I recommend not creating more than 25 pages per document. If you do too many, it will slow down your Word doc and you will have problems with it freezing and crashing.)

If you are not familiar with mail merge, the easiest thing to do is to copy and paste your addresses manually. I know from experience that it only takes 20 minutes to copy 100+ envelopes, which is how long it will take to solve the mail merge problem.

If not, you can search Google for email integration instructions based on your software version and operating system.

Printable Envelope Address Templates [word] ᐅ Templatelab

Load several envelopes into your printer’s paper tray. (If yours has one, I would use the rear feed tray as opposed to the bottom paper cassette. If you don’t have one, don’t panic.)

Be sure to enter a custom paper size in your print settings or, no matter what you do, you won’t print correctly. Then go back to print preview and make sure the text is the right size, centered and nothing is cut off.

If you want to grab our free A7 envelope template to use in Microsoft Word (the same one I used in this post!), just click here.

Hi, I’m Stephanie and welcome to the Pipkin Paper Co. Blog. This is where our love of wedding books and DIYs come together. We’ll show you how to plan the wedding of your dreams without breaking the bank.

How To Print Envelopes The Easy Way

This website uses cookies to improve your experience. We’ll assume you’re okay with that, but you can opt out if you want. Accept cookie settings

This website uses cookies to improve your experience while navigating the website. In the cookies, cookies exist