How to Print Place Cards From Spreadsheets
card image by tholi75 from Fotolia.com
Whether you need to assign seats for guests at a wedding, or participants at a business conference, people will appreciate knowing where to sit. Printed place cards will not only help people find their places easily but they also lend an air of professionalism to your event.
With a little work, you can print place cards from a spreadsheet, even if you have a long list.
Open or create your list of names in your spreadsheet program. For this example, we will use Excel 2007. Make sure each column is labelled; the column name will be used for a mail merge. For example, if your first column contains the names, you might give that column the name "Name" in cell A1. If your second column contains a table number for each person, that column might be labelled "Table_Number" in cell B1.
- Whether you need to assign seats for guests at a wedding, or participants at a business conference, people will appreciate knowing where to sit.
- With a little work, you can print place cards from a spreadsheet, even if you have a long list.
Save and close your spreadsheet.
Open a new sheet in your word processing program. For this example, we will use Word 2007 but other programs have similar instructions.
Click "Start Mail Merge" under the "Mailings" tab. Select "Labels." Select the brand of place cards from the "Label vendors" drop-down box and its corresponding product number. For example, "Avery US Letter" and product number "5302" select a 4-inch tent card. If there is no appropriate label vendor or if you want to create place cards from scratch, click the "New Label" button. Enter the dimensions of the cards in the "Label Details" popup window. Click "OK" when you are done. You will now see a blank sheet in Word with outlines for your place cards.
- Save and close your spreadsheet.
- If there is no appropriate label vendor or if you want to create place cards from scratch, click the "New Label" button.
Click "Select Recipients" from the "Start Mail Merge" group. Click "Use Existing List." Find the spreadsheet name in your list of documents and click "Open." Your spreadsheet should now be linked to your empty mail merge document.
Insert the merge fields into the first empty place card. Click "Insert Merge Field" from "Write & Insert Fields." Select the fields you want to appear in your card -- for example, "Name" and "Table_Number." Apply any formatting to the fields that you want, such as bold, centring or different fonts. For example, you may want to hit "Enter" a couple of times to get to the centre of the card before inserting the "Name" field.
- Click "Select Recipients" from the "Start Mail Merge" group.
- Select the fields you want to appear in your card -- for example, "Name" and "Table_Number."
Click "Update Labels" from the "Write & Insert Fields" group to populate all the cards with the fields.
Click "Preview Results" to see what your cards will look like when they are printed. If you are satisfied with the results, you are ready to print.
Load the correct card stock or paper into your printer, according to your printer's instructions. Press "Print."
- Don't use spaces in the column names in your spreadsheet; instead, use an underscore or create column names without spaces.
Danielle Cort has been a freelance writer since 2008, specializing in psychology, health, education and parenting. She has published articles in "Family" magazine. Before becoming a freelance writer, Cort worked in the public policy research sector, conducting research, creating surveys and budgets. She holds a Doctor of Philosophy in social psychology from the University of Massachusetts.