|
|
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.
|
