Post # 1
I was wondering how to enter addresses into Excel so that I can easily print envelopes for Save-The-Date Cards, invites, etc… I have my guest list names in excel and just want to enter everything correctly now so it’s easier later.
Do I need each separate line of the address in a different cell? Do I put the complete address in one cell? I assume you can list the people in a vertical column…
Post # 3
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.
Post # 4
i had each part of the address in a separate column. “name” “street address” “city” “state” “zip”
Post # 5
Thanks ladies! That helps.
Post # 6
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
Bookmarking this! Thanks ladies!