B03 Using Mail Merge with a Numbers Document 1:58

prev < Pages ’09 > next

1
00:00:01,201 --> 00:00:03,303
Using Mail Merge with Numbers

2
00:00:03,303 --> 00:00:06,439
With Pages '09 you can
customize the document

3
00:00:06,439 --> 00:00:09,576
using any data from a table
in a Numbers spreadsheet.

4
00:00:09,576 --> 00:00:11,778
This makes it easy to generate letters,

5
00:00:11,778 --> 00:00:15,048
invoices, brochures or
any other document

6
00:00:15,081 --> 00:00:17,283
with personalized informations.

7
00:00:17,283 --> 00:00:20,453
This Pages document is a
new listing notifications

8
00:00:20,453 --> 00:00:24,124
to be sent to pretension buyers 
on a MILEA ready mailing list.

9
00:00:24,124 --> 00:00:26,826
To access the data from
a Numbers spreadsheet

10
00:00:26,826 --> 00:00:29,195
first open the Inspector

11
00:00:29,195 --> 00:00:31,598
click the "Link" icon

12
00:00:31,598 --> 00:00:34,801
and select "Merge"

13
00:00:34,801 --> 00:00:36,136
click "Choose..."

14
00:00:36,136 --> 00:00:39,639
and select the Numbers document
as your mail merge source.

15
00:00:43,476 --> 00:00:45,678
Then select the table
within that document

16
00:00:45,678 --> 00:00:48,782
that contains the data you want
included in this letter,

17
00:00:48,782 --> 00:00:51,351
and then click "OK".

18
00:00:51,351 --> 00:00:53,620
Next place the cursor on your letter

19
00:00:53,620 --> 00:00:55,855
where you want the
addresses name to appear

20
00:00:55,855 --> 00:00:57,991
and click the plus button in the inspector

21
00:00:57,991 --> 00:00:59,592
to add a merge field.

22
00:00:59,592 --> 00:01:01,161
By clicking the target name

23
00:01:01,161 --> 00:01:04,397
you can change the data source
from your Numbers table.

24
00:01:04,397 --> 00:01:06,232
You can continuing adding merge fields

25
00:01:06,232 --> 00:01:08,635
to include all the personal informations

26
00:01:08,635 --> 00:01:11,271
associated with each individual client.

27
00:01:11,271 --> 00:01:13,039
from addresses and phone numbers,

28
00:01:13,039 --> 00:01:15,341
the budgedt and the
preferred square footage.

29
00:01:21,614 --> 00:01:23,817
When you finish adding
all your merge fields

30
00:01:23,817 --> 00:01:26,286
you can instantly create a version of the letter

31
00:01:26,286 --> 00:01:28,188
for everyone on the mailing list.

32
00:01:28,188 --> 00:01:30,924
Choose "Edit",

33
00:01:30,957 --> 00:01:34,594
"Mail Merge...",

34
00:01:34,594 --> 00:01:39,199
and then choose "New Document"
from the "Merge to:" pop-up menu.

35
00:01:39,199 --> 00:01:40,767
When you click the "Merge" button

36
00:01:40,767 --> 00:01:42,802
a new Pages document opens

37
00:01:42,802 --> 00:01:46,039
containing a page for each
person on your mailing list

38
00:01:46,039 --> 00:01:49,342
which you can then use
like any other Pages document.

39
00:01:49,342 --> 00:01:52,345
With Pages you can easily
pull data from Numbers

40
00:01:52,345 --> 00:01:55,548
and quickly personalize
multiple documents.
All videos are copyright by Apple Inc.; transcriptions, subtitles and translations are volunteer efforts by members of this wiki.