share

Hi friends, happy Monday! Although this post might be a little late for the Holiday season, I thought I would share with you a quick little tutorial on how to automate and print addresses on envelopes using custom fonts. This is a perfect way to quickly print addresses on your envelopes using gorgeous calligraphy fonts! Aka: […]

Post intro

How to automate and print addresses on envelopes using custom fonts

Tutorials & Freebies

Hi friends, happy Monday! Although this post might be a little late for the Holiday season, I thought I would share with you a quick little tutorial on how to automate and print addresses on envelopes using custom fonts. This is a perfect way to quickly print addresses on your envelopes using gorgeous calligraphy fonts! Aka: like this beautiful one HERE that I used for the sample (highly recommend it). Note: I did use InDesign and Numbers for this tutorial and will try to take a stab at using Word for those without InDesign.

print addresses on envelopes using custom fonts

See the video below for the full process and the step-by-step tutorial below on how to automate and print addresses on envelopes using custom calligraphy fonts!

–  VIDEO HERE –   |   – TEMPLATE HERE + HERE –   |   –  FONT HERE  –

TUTORIAL STEPS

1. Setup excel/numbers and input addresses (Get Numbers Template HERE or Excel template HERE)

2. Export to CSV (without any empty cells)

3. Create Document in InDesign File (ex: 7”x5”)

4. Create 2 text boxes: One for the name and one for address (fill with placeholder text)

5. Style Each text box: font, spacing, formatting you wish to use on envelope

6. Setup ‘Character Styles’ for each box – Highligth the text, choose — ‘Type’ — ‘Character Styles’ — Choose ‘New Character Style’

7. Under ‘Data Merge’ Choose ‘Select Date Source’

8. Set each ‘source’ to coordinate with the text boxes. – Highlight the typed out name and select ‘name’ under ‘data source’ — repeat with address

9. Under ‘Data Merge’ choose ‘ Create Merged Document’

10. Fix and names that need slight adjustments

11. Save as PDF or Print for a 5×7 setup (this depends on your printer).

 

And please let me know if you have any questions!

I Think You'll Love...

Leave a Reply

Your email address will not be published. Required fields are marked *

  1. Pamela says:

    Thank you for the great tutorial! I was wondering what serif font you used for the address.

  2. Jennifer Edge says:

    I have the same envelopes (A7). I’ve tried everything to have my addresses printed. Can you tell me what printer you are using that will allow you to print envelopes?

  3. Taylor Catherine Glomb says:

    These are beautiful! where did you get the return address labels?

  4. Heather says:

    Hi! I have a more generic question regarding postal regulations — I’ve always seen things like this done, but wonder what hoops you have to go through to get this to go through the mail? Do you have to pay higher postage to have this hand sorted? Or could you literally drop one of these with a normal stamp into your own mailbox? (Hope this made sense haha.)

    • Angela says:

      I’ve never had issues before! The only time I would have something hand sorted is if you want to make sure the envelope doesn’t get banged up (if using wax seals, specialty envelopes, etc). Really, the only time I found issues was the delay in mailing black envelopes with white writing..but never have had anything returned!

  5. Angel says:

    Absolutely love your envelopes and design! Do you have a tutorial on how you can set up your own template for the wrap around labels? I have an idea, but want to make it cleaner like you have it on your zazzle page!

    Thanks!!

    • Angela says:

      Hi there,
      If you have a design program, I would probably just buy sticker labels from office depot and then print on them and cut by hand!

  6. […] your own invitations with script font using just your printer [and a design program if available]. I ordered customized stamps from […]

  7. Erin says:

    How did you make the “name” line slant upward?? I love it!

  8. Erin says:

    How did you make the “name” line slant upward? I love it!

  9. Sami says:

    Hi Angela!
    I followed your steps and my envelopes (in indesign) look great but each time I print them, it always prints left justified even if I change the setup to 5×7 borderless and center justify. Any tips?

  10. Krystina says:

    Hi did you ever make the tutorial for Word?

  11. Kelsey DeSantis says:

    What was the block font used for your envelope?