{"id":233,"date":"2016-06-13T23:46:53","date_gmt":"2016-06-13T23:46:53","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=233"},"modified":"2024-11-14T13:59:27","modified_gmt":"2024-11-14T02:59:27","slug":"how-to-use-data-merge-in-indesign","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign","title":{"rendered":"How to use Data Merge in InDesign"},"content":{"rendered":"\n

Data Merge is also called Mail Merge and is used when you want to combine a data source file with a target document. This is initially used to generate letters, mailing labels, letter heads, envelopes, etc.<\/p>\n\n\n\n\n\n\n\n

Steps for Data Merge in InDesign<\/h2>\n\n\n\n

STEP 1<\/span>: <\/strong><\/p>\n\n\n\n

Ensure that you have preliminary data ready in a Microsoft Excel Worksheet<\/strong>. This will be the data source file that holds the information that changes in each iteration of the target document, such as the names and addresses of the recipients of a form letter.<\/p>\n\n\n\n

\n
\"DataMerge-1-DynamicWebTraining\"
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 2<\/span>: <\/strong><\/p>\n\n\n\n

You will need to save this file as a CSV file<\/strong>. You can do so by going to File<\/strong> in the Menu Bar and then selecting Export \uf0e0 Change File Type \uf0e0 CSV (Comma delimited .*csv)<\/strong>.<\/p>\n\n\n\n

Note: A CSV File is a comma separated values file, which allows data to be saved in a table structured format.<\/em><\/p>\n\n\n\n

STEP 3<\/span>: <\/strong><\/p>\n\n\n\n

You will need to have a document ready in Adobe InDesign<\/strong>, which is known as the target document that contains the data-field placeholders etc.<\/p>\n\n\n\n

\n
\"DataMerge-2-DynamicWebTraining\"
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 4<\/span>: <\/strong><\/p>\n\n\n\n

Continue on by selecting Window from the Menu Bar then choosing Utilities \uf0e0 Data Merge<\/strong>.<\/p>\n\n\n\n

\n
\"DataMerge-3-DynamicWebTraining\"
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 5<\/span>: <\/strong><\/p>\n\n\n\n

There will be a small box that will open up for Data Merge<\/strong>, select the further options icon<\/strong> and from the drop down choose Select Data source<\/strong>.<\/p>\n\n\n\n

\n
\"DataMerge-4-DynamicWebTraining\"
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 6<\/span>: <\/strong><\/p>\n\n\n\n

The Select Data Source<\/strong> window will open up from which you can choose the CSV<\/strong> file you saved earlier. Once you have chosen the file, press Open<\/strong>. This will link your CSV<\/strong> file with the InDesign<\/strong> file.<\/p>\n\n\n\n

\n
\"DataMerge-5-DynamicWebTraining\"
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 7<\/span>: <\/strong><\/p>\n\n\n\n

As the window closes and you return to the Data Merge<\/strong> drop box you will see numerous data fields in the Data Merge<\/strong> panel.<\/p>\n\n\n\n

\n
\"DataMerge-6-DynamicWebTraining\"
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 8<\/span>: <\/strong><\/p>\n\n\n\n

In your InDesign document within the text boxes, click and enter wherever you want the fields (First Name, Last Name, Suburb etc.) to show up. You will see that as you select the fields they will appear in the following format:<\/p>\n\n\n\n

<<Last Name>> – Last Name<\/p>\n\n\n\n

\n
\"DataMerge-7-DynamicWebTraining\"
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 9<\/span>: <\/strong><\/p>\n\n\n\n

Once you have completed adding in the links, within the Data Merge<\/strong> panel from further options<\/strong> select Create Merged Document<\/strong>.<\/p>\n\n\n\n

The merged document<\/em> will be the final InDesign document that will hold the boilerplate information from the target document.<\/p>\n\n\n\n

\n
\"DataMerge-8-DynamicWebTraining\"
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 10<\/span>: <\/strong><\/p>\n\n\n\n

The Create Merged Document<\/strong> pop up box will open up and once you have reviewed all information (there is no need to alter any of it), select OK.<\/p>\n\n\n\n

\n
\"DataMerge-9-DynamicWebTraining\"
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 11<\/span>: <\/strong><\/p>\n\n\n\n

It will take a few seconds to create the merged document with a following pop up box stating if any text has been overset. Alongside InDesign will create numerous pages holding separate information coinciding with the Excel file.
Once complete you are free to export the file and use.<\/p>\n\n\n\n

\n
\"DataMerge-10-DynamicWebTraining\"
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

Data Merge is also called Mail Merge and is used when you want to combine a data source file with a target document. This is initially used to generate letters, mailing labels, letter heads, envelopes, etc.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-233","post","type-post","status-publish","format-standard","hentry","category-adobe-indesign"],"yoast_head":"How to use Data Merge in InDesign - Dynamic Web Training<\/title>\n<meta name=\"description\" content=\"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use Data Merge in InDesign - Dynamic Web Training\" \/>\n<meta property=\"og:description\" content=\"A data merge, also known as a mail merge, is a process used to merge a data source file with a destination document for document variations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign\" \/>\n<meta property=\"og:site_name\" content=\"Dynamic Web Training Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-13T23:46:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-14T02:59:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/06\/DataMerge-1-DynamicWebTraining-1.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"name\":\"Dynamic Web Training Blog\",\"description\":\"The Ultimate Training Experience.\",\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/06\/DataMerge-1-DynamicWebTraining-1.jpg\",\"width\":462,\"height\":454},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign#webpage\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign\",\"name\":\"How to use Data Merge in InDesign - Dynamic Web Training\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign#primaryimage\"},\"datePublished\":\"2016-06-13T23:46:53+00:00\",\"dateModified\":\"2024-11-14T02:59:27+00:00\",\"description\":\"A data merge, also known as a mail merge, is a process used to merge a data source file with a destination document for document variations.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"name\":\"Training Blog\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"name\":\"Training\"}},{\"@type\":\"ListItem\",\"position\":3,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/adobe-indesign\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/adobe-indesign\",\"name\":\"Adobe InDesign\"}},{\"@type\":\"ListItem\",\"position\":4,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign\",\"name\":\"How to use Data Merge in InDesign\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign#webpage\"},\"author\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"How to use Data Merge in InDesign\",\"datePublished\":\"2016-06-13T23:46:53+00:00\",\"dateModified\":\"2024-11-14T02:59:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/how-to-use-data-merge-in-indesign#primaryimage\"},\"articleSection\":\"Adobe InDesign\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"Dynamic Web Training is Australia's leading provider of instructor led software training. We offer training courses in Adobe, Web Design, Graphic Design, Photoshop, InDesign, Dreamweaver and many more.\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"]}]}<\/script>","_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=233"}],"version-history":[{"count":3,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/233\/revisions"}],"predecessor-version":[{"id":1958,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/233\/revisions\/1958"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}