Post # 1
I love using Google Docs spreadsheet for my wedding related items because I can work on them at home but also work on them during my lunch breaks at work. When I was playing around with the spreadsheets, I noticed a “form” option. I then a found great solution to just send out a form to my entire guest list for them to send me their address and Google Docs automatically places their address into a spreadsheet.
You must already have a google account for this. Create New: Form
You need to then create the fields for the user to fill out. I only had two fields for them – name and address. That way whoever fills out the form will be always remember to add their name so you do’t have to guess who lives where. Here’s how my form fields look:
You also can choose the theme of how the form will look to whoever you email to. Just click: Theme
Here’s how my form looks to whoever I emailed it to:
Email the form!
View responses. Here’s how all the responses will look:
Then you can sort the list however you like. You can also save the file as an Excel file and use it there if you’re more comfortable with Excel. I ended up using my list to make a mail merge to print all my STD envelopes.
Post # 3
Thanks! Had heard about this, but had no idea how it worked. Will definitely be doing this over the weekend!
Post # 5
thanks– just did this myself– very easy to do and will help out a ton!
Post # 6
I did this as well but I made separate first name/last name fields. This makes it easy to find specific people when I sort by last name. I also made a field for the name of the spouse/significant other to get a rough estimate of plus ones. The resulting sheet is being used for all things guest related. I’m tracking whether or not they’ve been sent a Save the Date or invitation as well as seating assignments and eventually what gift they gave and whether or not they received a thank you card.
Post # 7
This is AMAZING! Thank you so much for the tutorial. I’m excited to send out some emails and put this baby to work.
Post # 8
Awesome! This will make it a LOT easier to get addresses for J’s friends! It’s a man friendly tool 🙂
Post # 9
Thank you so much!
This is absolutely cool, and my very geeky fiance is super impressed.
I built the form, sent him an email and tried taking credit for it but he caught on an said “Where’d you learn about this? Weddingbee, eh?”
I admitted – I am nothing without the help of all the wise ladies here!
I cannot wait to finalize our guestlist so that we can send this form along its way!