(Closed) Organizing Addresses

posted 7 years ago in Parties
Post # 2
Member
2175 posts
Buzzing bee
  • Wedding: August 2014

View original reply
MrsPhishBee:  It won’t help for printing but I used Excel on googledocs and it’s so convenient even after the wedding.  I love that I can pull up the address of anyone I know on my phone at any time.  I continue to update it, it made baby shower thank you cards so easy too.

I also used it to track who was invited to the rehearsal, gifts we received, who we’d already sent a thank you card to, how many of the people invited in the family were children under the cutoff age for our venue, all that kind of stuff.  I even had codes for what type of guest each person was so I could sort by that, made creating a seating chart really easy and then when I’d assigned everyone to a table I added a column for that so I could make sure I didn’t have any table too full at a glance.  …Can you tell I’m totally obsessed with Excel?  It’s like my nerd guilty pleasure.

Post # 3
Member
521 posts
Busy bee
  • Wedding: City, State

View original reply
MrsPhishBee:  I organized my guest list/addreesses by making my own Excel Spread Sheet with Guest names and addresses in another column. Anything else I needed like printing labels I just copied and pasted to word etc from that original list (usually had word and excel open at the same time it made things alot easier). I also did my meals (how people wanted their meat cooked or if they wanted the alternative in an excel spread sheet as well and just used the columns. I felt I was completely orgainzed using this. My photographer (she use to be a wedding planner) sent me some stuff to use but to me it over complicated what I was going for and I wanted to keep things simple. 

Post # 4
Member
3791 posts
Honey bee
  • Wedding: October 2014

We used a program called Address Manager, where we have everyone’s addresses for various events. Then you just print which ones you need on labels and you’re done. We’re currently using it for Thank You Cards and Christmas Cards. There is a free version, but DH just bought the full copy since we’ll be using it into the future. It made everything SO much easier.

We used it for our invitations, as well as for our place cards.

Post # 6
Member
881 posts
Busy bee

I opened up in Google drive a spreadsheet doc and set up the categories that were relevant to our wedding. I did grab some of the categories from a general template I found but added and deleted as I saw fit. There are a LOT of columns here, and I will probably end up deleting the ones for the rehearsal dinner stuff, etc, but for our Destination Wedding it works.  

I did our address writing for our save the dates in handwriting, not sure what I’m going to do with the invitations yet. I know you can do a mail merge of them from Excel or Word so that might be easier. My Fiance and I just find it easier personally because we share documents with Drive and we can add to our lists/spreadsheets as we get them on our phones or on the computer. 

I’m interested to hear what other bees do to keep things organized! 

 

EDIT: apparently copy and paste creates havoc on the bee, sorry! Categories are below:

Last Name

First Name

Total Guest Numbers

Booked Deposit

Address

Email

Telephone

Dietary Restrictions

Sent Save the Date

Sent Email Reminder About Deposit Due Date

Sent Invite

Number Invited Guests – Wedding

Wedding – Attending

Children

Number of Invited Guests – Rehearsal

Rehearsal – Attending

Table

Description of Gift

Notes

 

  • This reply was modified 6 years, 10 months ago by jlc3.
Post # 7
Member
1172 posts
Bumble bee
  • Wedding: May 2014

View original reply
MrsPhishBee:  Google Drive/Docs/Sheets is a utility of Google. If you have a GMail account or Google+ account, you can tie it to Google Docs. All of your spreadsheets are stored on the web, so you can access it from any computer you use. You can also share it with others to also edit, so that you’re all on the same page (figuratively).

google.com/sheets

Post # 8
Member
2175 posts
Buzzing bee
  • Wedding: August 2014

View original reply
MrsPhishBee:  Just go to docs.google.com, click on the three horizontal lines in the top left corner and choose sheets.  Then at the bottom right there’s a plus sign, click on it and you have a new Excel spreadsheet.  I don’t have a template really, I just added a column for each detail I wanted to track.  And if you want to sort by any of those columns just go to Data and select Filter, it’ll add a little triangle next to each of your column headers and when you click on the triange it’ll allow you to sort by that column.  Hope that helps!

Post # 9
Member
2221 posts
Buzzing bee
  • Wedding: May 2015 - Walnut Hill Bed & Breakfast

I started out by downloading the template for The Knot and them imported them in there. I used photoshop to print my invitations and did them 1 at a time copying or typing in the address for each… but I only have about 50 to do. 

Post # 10
Member
2221 posts
Buzzing bee
  • Wedding: May 2015 - Walnut Hill Bed & Breakfast

And I stored it in iCloud’s Numbers application… similar to google docs.

Post # 12
Member
2221 posts
Buzzing bee
  • Wedding: May 2015 - Walnut Hill Bed & Breakfast

View original reply
MrsPhishBee:  if you go to icloud.com you can open & access your numbers files there (email it to yourself) and use them on the web. Can even share them… I shared mine with my mother-in-law and mom so they could add family addresses for me. 

Post # 13
Member
5879 posts
Bee Keeper

Another vote for Google Docs.

Post # 14
Member
1088 posts
Bumble bee
  • Wedding: August 2015

View original reply
MrsPhishBee:  The nice thing about Google Docs too is that you can ‘share’ the files with multiple email addresses, so your FI/parents/his parents can all help and add addresses or other info the files you create. 

The topic ‘Organizing Addresses’ is closed to new replies.

Find Amazing Vendors