Click the ‘Open’ button.ġ0: In the ‘Select Table’ dialog box let it use the default table (usually your filename with a $ at the end), make sure ‘First row of data contains column header’ is ticked and click ‘OK’.ġ1: In the ‘Mail Merge Recipients’ dialog box just click ‘OK’. (Don’t use the ‘Labels’ option because that’s for getting data to repeat many times on the same page).ħ: Make sure ‘Use the current document’ is selected and click ‘Next: Select recipients’Ĩ: Make sure ‘Use an existing list’ is selected and click ‘Browse’ĩ: In the ‘Select Data Source’ dialog box browse to and select the Excel file you saved in Step 2. Once you’ve done that you should have something that looks like this:ĥ: From the menu bar select ‘Tools’ then ‘Letters and Mailing’ then ‘Mail Merge’Ħ: Make sure ‘Letters’ is selected and click ‘Next: Starting document’. this is important later and the Zookeeper almost always forgets!Ĥ: Download and open one of our label templates and follow the instructions to clear out our sample text and images. The Zookeeper really likes when he wants test names and addresses it saves him having to make them up for himself! Be warned, a little technical know how is needed, so if you’re happier typing in the names for your test, just copy the ones above.Ģ: Save your Excel file with a name you can remember: namesandaddresses.xls or similar will be fine.ģ: Close your excel workbook.
Make sure you use the first row for column headings create as many columns as you think you’ll need. These instructions can be helpful to merge data from an Excel spreadsheet into pretty much any document they are however even more useful for merging names and addresses into any of our integrated labels.ġ: Use Excel to create a list of names and addresses that looks something like this:
#Mail merge from excel to word labels how to#
The following instructions show how to mail merge using Word and Excel 2003.
0 kommentar(er)
