Post # 1
Most of my friends move around so much, I never have up to date addresses for them – for me, their email address is their most permanent address. 😛 So for Save-The-Date Cards, I needed to get everyone’s addresses quickly. So here’s how I utilized my beloved Google to assist me to get everyone’s 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 loo
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
Looks very easy! (and pretty)
Does the recipient have to be a google mail user?
Post # 4
there is also a template for you to email the users on google (i LOVE google lol)!!! it’s how i created my save the date slide show..
@jojo: yeppers you have to have a google account http://www.google.com
Post # 5
@jojo: If you’re creating the form, you need a google account. However, the recipient does NOT need a google/gmail account. And it is really easy – it only took about 5 – 10 minutes to create the form.
@crebre80: such a great idea – i would never have thought about doing a slideshow as a STD!
Post # 7
Let me know if anyone ends up using this form for their addresses – I’d love to know what you thought of it!
Post # 8
Looks awesome! We used a similar program to make a reply form on our wedding website where our guests can tell us their travel and hotel plans. (Our wedding is basically a destination wedding as 95% of the guests will be from Out of Town.) I figured the form would give us all the info we needed for delivering Out of Town bags to our guests. Plus, we can use the replies of where people are staying to guage interest in a trolley shuttle to the wedding.
I wish I had known about google forms though. Does the google form generator allow you to imbed the form into a website? The program we used was definitely more complicated, and sometimes the form crashes for no apparent reason 🙁 Google always makes things easier.
Post # 9
@skibobrown – Yes, you can embed the form in a webpage. It’s under a button called “More Actions”.
Post # 10
That’s BRILLIANT! Why have I never heard of this until now? Man, it would have saved me some time searching through endless papers finding my friend’s addresses. But I have my system now….
Post # 11
Thanks for posting, this is awesome! I just tried it – very simple! This is so much easier than trying to type up everyone’s info or cut and paste from e-mail. I added separate forms for the street, city and state so that I can use the spreadsheet to do a mail merge and print envelopes/ labels.
So cool! What else can we do with google?
Post # 12
Forgot to add:
I like that we can make the fields required so that we don’t end up with street addresses and no zip codes.
Post # 13
There’s a cute new website called Postable designed only to gather mailing addresses http://www.postable.com It’s pretty great, it’s Free and you can export as excel and print labels too.
Post # 14
I used Google Docs and Google Sites for everything for our wedding. I love how Google Sites seemlessly integrates Google Doc forms and spreadsheets.
In addition to using a form similar to OP’s, I also created an RSVP form, which dumps into our RSVP spreadsheet. It’s giving us a running tally of who will be needing transportation, going to the Thursday night baseball game, etc.
I’ve made a copy of our RSVP form for anyone who wants to play around with it – it’s not our real RSVP, so go nuts!!