PW Guide Article: Best Program for Your Guest List

Ladyjenn submitted an article for the Project Wedding Guide. This is a community article that you can edit too!

Best Program for Your Guest List article photo

Feel free to comment on it here!
Posted on August 30, 2009 at 6:01 pm
mabv812
4
07/23/2010
mabv812

mabv812

  • 4
  • 14
  • 3.08k
247
Followers
250
Following

(2) Comments

MRS1910
1
01/09/2010
MRS1910

MRS1910

  • 1
  • 1
  • 136
1
Followers
5
Following

MRS1910

I used excel as well.  Type "Mail Merge" into the help bar and some pretty easy directions will come up for your label creation. 


For the actual set-up of the spreadsheet(s), I did the following: 



  • Columns I have are Last Name, First Name, Phone Number (for no-RSVP callbacks), address 1, address 2, City, State, Zip, Relation (Bride's family, Bride's friend), # invites, Kids invited, adults invited, total invited, kids anticipated Y, adults anticipated Y, total anticipated Y, kids RSVP Y, adults RSVP Y, total RSVP Y. 

  • I put formulas in the last row so that I could easily tell what I was at for # invites needed to order, total guest count if everyone says yes, total guest count anticipated, total guest count RSVP'ed Yes.

  • Create other tabs for special events to give to the hosts, using some of the same column headers name, address, phone, relation or whatever you think your host needs.  (engagement party, shower(s), bachelorette, groom's/rehearsal dinner, etc.).  A copy of this could be used for the gift recording to make thank-you's that much easier.

  • Anticipated numbers are nice so we could start looking at venues and vendors that matched our event size if everyone invited actually came.  We needed expected counts, so that we could actually be realistic in getting a range for guests.  Once the invites are sent out, we will use the RSVP'ed yes columns to track attendees.

  • If you have other options (meal choice for example), you can just add another column to track that on the spreadsheet.

Posted on August 31, 2009 at 3:33 am
mrsgennisgarcia
1
06/09/2012
5
Followers
9
Following

mrsgennisgarcia

I'm using WeddingMapper.com currently.


It's awesome!.. mostly since it's fill in the blank and also has a virtual Seating chart that already uploads my guest list and i drag and drop names to the correct table. So happy for the referrence on this forum. I love all my PW brides. Don't know what i'd do without this site.

Posted on May 22, 2012 at 10:25 am

Have a question? Contact Support
Top Contributors this Week
Canooknic
17 posts
Levisjoe
15 posts
LauraSweet
9 posts
Uhlease
9 posts
lorna247
7 posts
zeuster
6 posts