Wedding Guestlist Template
Use this free Wedding Guestlist Template to track your wedding invitations and RSVP's. This new spreadsheet is an updated version of our original wedding guest list for Excel 2003. It still lets you do the same things as before, such as estimating costs for the dinner and reception, but now it's more pleasant to look at. Colors and decorations are an important part of your wedding, so we figured the tools you use might as well look good, too.
Wedding Guestlistfor Excel
"No installation, no macros - just a simple spreadsheet" - by Jon Wittwer
This template provides an efficient way to keep all the your wedding guest info in one place. It allows you to keep track of the names and contact information of those you've invited to attend your wedding dinner and wedding reception. It also lets you record the gifts they gave.
If you know the cost per person for your dinner and reception, the template will automatically give you a total cost for each based on how many guests you've listed as attending. If the person in charge of collecting your guest information doesn't have access to a computer, you can easily print this out and they can fill it in by hand.
Creating Address Labels
Before using Word to do a mail merge, copy the addresses from your guest list into the first worksheet in a new Excel file with the labels as the first row in the worksheet. Then save that new file somewhere convenient. You can then use that Excel file as the Recipient List when doing your mail merge. (You may need to manually match the ST field to State, or change the label to State).
See the article Mail Merge Using an Excel Spreadsheet on the support.office.com site to learn how to do a mail merge.