(Closed) Entering addresses into Excel for printing envelopes?

posted 7 years ago in Technology
Post # 3
Member
209 posts
Helper bee
  • Wedding: September 2010

You can do it using mail merge.  Mail merge lets you take a list of names and addresses from excel and formats it to be printable on envelopes.  

If you’ve never done a mail merge before, this video might be helpful.

http://www.youtube.com/watch?v=_9ExKwXQ3KQ

Post # 4
Member
273 posts
Helper bee
  • Wedding: January 2011

i had each part of the address in a separate column.  “name” “street address” “city” “state” “zip”

Post # 6
Member
97 posts
Worker bee
  • Wedding: March 2011

I use Word. You can go under Tools, Letters and Mailings, Envelopes and Labels. I already bought sticker labels and you can find them under the list (i.e. Avery Template 5160). That way you can type everyone’s name and address into the label slots and hit print.

Post # 7
Member
1506 posts
Bumble bee
  • Wedding: July 2011

Bookmarking this! Thanks ladies!

The topic ‘Entering addresses into Excel for printing envelopes?’ is closed to new replies.

Find Amazing Vendors