First Mtg Tonight!
more by KLP2010
What a disaster!
"Together with our parents" wording
more in Paper
First go at STDs
I got the job :)
more in Boards
Party Afterwards

Organizing Addresses

posted 2 years ago in Paper
  •  
    1.
    Member
    4,199 posts
    Honey bee
    KLP2010    October 30, 2010  

    OK, don't know if there's another thread already, but being in the first stages, I know I gotta wrangle the guest list!

    As we finalize the list and get everything together, what have you found to be the best way to format a list?  I plan on doing my own STD's and Invitations... so I know I'll need to print addresses on PostCards and Envelopes.  

    I'm not the best at Excel and what not so I'm not sure if there's a trick to how I should organize all my addresses to make printing easier, or a method that works well. I've also never printed to envelopes before so... what to do!

     
    2.
    Member
    2,130 posts
    Buzzing bee
    texasmeredith      

    We are using excel.  Its by far the easiest way.  It is well worth your time to learn excel, even if you only use it for this purpose. 

     
    3.
    Hostess
    1,913 posts
    Buzzing bee
    IA_Snowflake    August 29, 2009   Missouri Valley, IA

    If you're planning on doing the mail merge tool, you could either put them in excel or outlook.  I found excelt the easiest, but if you don't mind filling in all those business cards in outlook, that's easy too.

     
    4.
    Member
    904 posts
    Busy bee
    jocelyn3476       New Jersey

    Do you have a huge guest list?  There are ways to insert addresses on labels in word, but have you thought about handwriting the envelopes if the number of envelopes isn't insane?  Not only would it be easier, but Emily Post would approve.

     
    5.
    Member
    1,398 posts
    Bumble bee
    Miss Sapphire    December 2009   Seattle

    Excel is by far the easiest to mail merge. 

     
    6.
    Member
    2,518 posts
    Sugar bee
    KellyV    September 12, 2009   New York, NY

    ok, so go to weddingwire.com or some other site (brides.com, theknot, etc) and use their guest list tool.  Get everyones addresses in there.  Once they are all in there, you can export the guest list into an Excel Format (of you need help with that, PM me) and its all right in front of you.  After that, you can copy and paste onto an envelope template (for my various projects, I size down a blank Word Document into envelope size.  5x7 in my case) so that way, you see what it will look like on screen. :)

     
    7.
    Member
    1,176 posts
    Bumble bee
    jhphi    January 1, 2008  

    I agree that having them in Excel makes it very easy to search, sort, etc.  I'd go to weddingwire.com and check out what format their guest list manager wants-- if it's one column for first name, one for last, etc.-- and keep yours in that format, so that you can use the seating tools a little later on in the process.  They were very helpful for me!

    It's also helpful to have in Excel as you can continue to add information, like for gifts received, thank you notes sent, hotel arrangements, etc.

     
    8.
    Member
    2,518 posts
    Sugar bee
    KellyV    September 12, 2009   New York, NY

    also with weddingwire - their Guest Seating application is by far the best one I tried.  Its a great tool

     
    9.
    Member
    4,199 posts
    Honey bee
    KLP2010    October 30, 2010  

    We're looking at a pretty large list - 200-250 and my handwriting looks like a 3rd grade boy's so... that's out of the question! lol.

    I'll go check out wedding wire.  Thanks for all the help, keep up the suggestions!

     
    10.
    Member
    1,542 posts
    Bumble bee
    rabbit    September 3, 2010   Milwaukee, WI

    I had this problem (and we've only got 131 people on our guest list so far!) until I stumbled across this website:

    http://weddings.shanbritedesigns.com/templates.htm

    Scroll down to Guests and both "guest list worksheet" and "guest list spreadsheet" are useful for dealing with guests lists (or so I have found). Plus, that site has a bunch of other super awesome things I've found useful! Explore it a little! :)

     

    Good luck!

     
    11.
    Member
    286 posts
    Helper bee
    kate6214    July 17, 2010   Maryland

    I know I am planning on doing something like Ms. Fondue and Mrs. Cowboy Boot using a google form.

    http://www.weddingbee.com/2008/12/01/getting-addresses-for-invitations/

    http://www.weddingbee.com/2009/07/16/the-handiest-wedding-tool-yet/

     

     
    12.
    Member
    4,199 posts
    Honey bee
    KLP2010    October 30, 2010  

    Wow, that google form feature is amazing! Looks like I'll be spending some time checking out google docs - never thought it was really anything.  Oops! 

     
    13.
    Member
    2,526 posts
    Sugar bee
    GaBGal    September 25, 2010  

    We are using a combo of Excel and Google Docs.

    There are several wedding websites that can help organize too like weddingtracker and weddingwire

     
    14.
    Member
    515 posts
    Busy bee
    WindyCityBride    September 25, 2010   Chicago, IL

    We got our spreadsheet from theplunge.com -- it's great.

     
    15.
    Member Icon
    Member
    97 posts
    Worker bee
    jbsgirl    May 2010  

    We're doing the google form thing and it's working fabulously so far

     

    Reply

    You must log in to post.





    Visit our sister sites eHarmony
    Online Dating
    eHarmony Advice
    Dating Advice
    Project Wedding
    Wedding Songs
    JustMommies
    Pregnancy Calendar
    Copyright 2004-2012, Weddingbee.com
     

    Find your vendors on Weddingbee

    Real reviews from brides in your area!

    Favors by Weddingbee

    • Favors by season

    Shop Now ยป

    Find Registry Find Registry Find Registry

    More
    User Posts Today
    MissBoPeep 89
    beargoose 54
    hisgoosiegirl 51
    Mrs.KMM 46
    akp0702 41
    ndreighton 40
    BetterSherm 38
    stardustintheeyes 36
    Beckster329 36
    MrsPom 35

    Paper

    User Posts Today
    BetterSherm 6
    LindsayB 3
    SweetVanity 3
    KCKnd2 3
    Kym080412 2
    Dandelion D 2
    Beckster329 2
    MsMindle 2
    JeniRae 1
    julies1949 1
    More