Microsoft Office Tutorials and References
In Depth Information
Selecting recipients in Word
To bring our Excel address book into Word, we need to ‘select recipients’. This is
another example of Word being very focused on mailings. If you were doing a
project that didn’t involve posting anything (such as creating a series of posters
using slogans organised in Excel), you would still need to use this button to bring
your information from Excel into Word.
Click Select Recipients on the ribbon and choose Use Existing List from the menu
that opens. A new window will open with a lot of technical jargon in the middle
of it (shown in Figure 6.4) or it might tell you that no items match your search. This
is the best kind of jargon, though, because you can completely ignore it. Use the
options on the left to go to the Desktop, Documents or Computer and then
navigate to your Excel ﬁ le as you would normally when opening a ﬁ le. When you’ve
found your ﬁ le, double-click on its ﬁ le name, or click it once to select it and then
click the Open button.
Don’t click the New Source button. If you click it by mistake, click the
Cancel button to go back a step.
A new window will open, which looks like Figure 6.5 for my address book. Excel
enables you to have more than one spreadsheet in the same ﬁ le, so your results
might vary. You can switch between them using the tabs at the bottom of the
spreadsheet (named Sheet1, Sheet2, Sheet3) and can add a new one by clicking
the Insert Worksheet tab beside them. For most simple projects, you won’t need to
worry about this, but Word might ask you to pick a worksheet now anyway. If it
does, choose Sheet1. Make sure the tickbox in the bottom left is ticked to indicate
that your data has headers at the top of it.