Jump to content
need help making printing address labels from an excel spreadsheet
1 reply to this topic
Posted 31 January 2011 - 02:03 PM
im on commitee at a sporting club and its time to get out the letters for registration day. i have an excel spreadsheet with all player details from last season and need to know how i can ust that excel spreadsheet to make address labels. i certainly dont want to be writing them all by hand (150 players!).
have been trying to get in touch with the lady who has done this job previously but am having no luck contactin her so any help would be much appreciated.
Posted 31 January 2011 - 02:30 PM
You need to open a new blank word document and from the tools drop down menu select 'letter and mailings' then 'mailmerge'
The mail merge helper should appear on the right hand side asking you to select what type of document.
Select Labels then 'next step" at the bottom.
It will ask you change the document layout - click the "Label Options link". A box will pop up containing all the different types of labels you can buy (Avery etc). Select the type and size of label you are using.
Your word doc should then automatically create the labels for you.
Then select 'next' down the bottom again to insert your addresses.
Select "Use an existing list" then click on the "Browse" button. Another pop up will open asking you to select your excel document containing all the addresses. If there is more than one tab in the document, make sure you select the correct tab.
The pop up box will then show the excel spreadsheet. Make sure you select each person you want a label for (tick on the left hand side) and click "OK".
Some grey fields should then appear <next record>.
Back in the helper on the left click "Next" down the bottom. This is where you arrange your labels. Click "Address Block" and then when the pop up box comes up, select the format etc you would like the names to appear, then click "Match Fields".
This will bring up a list of fields and a drop down box - for each field, click the drop down box and select the corresponding field from the Excel spreadsheet. Then click "OK".
Then in your 'helper' click the "update all labels" button.
You should see additional grey fields <address block>.
Then again click "next" at the bottom of your helper and it should create the labels for you!
I hope this is clear enough for you. They are fiddly, but once you get the hang of them they are pretty handy! PM me if you need any more help :-)
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users
Top 5 Viewed Articles