Adobe 17510676 User Guide - Page 62

About data merge, Understanding the data merge workflow, as many times as it takes to accommodate each

Page 62 highlights

58 CHAPTER 3 PageMaker Plug-in Pack Features About data merge To create form letters, envelopes, or mailing labels, you merge a data source file with a target document. The data source file contains the information that varies in each iteration of the target document, such as the names and addresses of the recipients of a form letter. A data source file is made up of fields and records. Fields are groups of specific information, such as company names or zip codes, whereas records are rows of complete sets of information, such as a company's name, street address, city, state, and zip code. A data source file can be a comma- (.csv) or tab-delimited (.txt) file, meaning a data format in which each piece of data is separated by a comma or a tab respectively. The target document is an InDesign document that contains the data-field placeholders, plus all the boilerplate material, text, and other items that remain the same in each iteration of the merged document. The merged document is the resulting InDesign document that contains the boilerplate information from the target document, repeated as many times as it takes to accommodate each record from the data source. A B , Adobe Systems, Inc. 345 Park Avenue C San Jose, CA 95110 dotPS Document Production Services 6365 Santana Row San Diego, CA 92110 Empowered Writing 17404 NE 25th Street Vancouver, WA 98684 Data merge A. Data source file B. Target document C. Merged document Understanding the data merge workflow Follow these basic steps to merge data. Each step is described in detail in the sections that follow. 1 Make plans to determine which data fields you'll be using in your source and target documents. (See "Planning a data merge" on page 59.) 2 Save the data source file-usually a spreadsheet or database file-as a comma-delimited (.csv) or tab-delimited (.txt) text file. (See "Working with data source files" on page 59.) 3 Create a target document that includes text and other items that remain the same in each version of the target document. (See "Setting up the target document" on page 60.)

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84

CHAPTER 3
58
PageMaker Plug-in Pack Features
About data merge
To create form letters, envelopes, or mailing labels,
you merge a data source file with a target
document.
The
data source file
contains the information that
varies in each iteration of the target document,
such as the names and addresses of the recipients
of a form letter.
A data source file is made up of
fields
and
records.
Fields
are groups of specific information, such as
company names or zip codes, whereas
records
are
rows of complete sets of information, such as a
company’s name, street address, city, state, and zip
code. A data source file can be a comma- (.csv) or
tab-delimited (.txt) file, meaning a data format in
which each piece of data is separated by a comma
or a tab respectively.
The
target document
is an InDesign document that
contains the data-field placeholders, plus all the
boilerplate material, text, and other items that
remain the same in each iteration of the merged
document.
The
merged document
is the resulting InDesign
document that contains the boilerplate
information from the target document, repeated
as many times as it takes to accommodate each
record from the data source.
Data merge
A.
Data source file
B.
Target document
C.
Merged document
Understanding the data merge workflow
Follow these basic steps to merge data. Each step is
described in detail in the sections that follow.
1
Make plans to determine which data fields
you’ll be using in your source and target
documents. (See “Planning a data merge” on
page 59.)
2
Save the data source file—usually a spreadsheet
or database file—as a comma-delimited (.csv) or
tab-delimited (.txt) text file. (See “Working with
data source files” on page 59.)
3
Create a target document that includes text and
other items that remain the same in each version of
the target document. (See “Setting up the target
document” on page 60.)
A
B
C
Empowered Writing
17404 NE 25th Street
Vancouver, WA 98684
dotPS Document Production Services
San Diego, CA 92110
Adobe Systems, Inc.
345 Park Avenue
San Jose, CA
95110
<<Company Name>>
<<Address>>
<<City>>, <<State>> <<Postal Code>>