From the course: Advanced InDesign: Productivity Techniques
Unlock the full course today
Join today to access over 25,200 courses taught by industry experts.
Solution: Creating personalized mailing - InDesign Tutorial
From the course: Advanced InDesign: Productivity Techniques
Solution: Creating personalized mailing
(Upbeat intro music) - Let's take a look at the solution of this chapter's challenge. Of course, everything in this chapter revolves around data. So that is where we're going to start with this solution as well. I'm here inside of Excel where I have the data already properly formatted. So the only thing I need to do is export this as a CSV document. I'll choose file, then I'll choose save as and I'll choose CSV UTF-8 comma-delimited dot CSV. You can name this, anything you want, I'll just go with customers for now. I'll choose, save and now we're done. Of course, this is the file I have here. And we have to be absolutely sure that Excel did a correct job when exporting this information to a CSV file. If your system settings on your computer are set to North America, then it will properly format and it will properly export by using commas. If you're not entirely sure because you might be based in different region…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Merging data57s
-
(Locked)
Preparing the data in Excel7m 4s
-
(Locked)
Placing placeholders5m 6s
-
(Locked)
Merging the document as a single-record layout3m 46s
-
(Locked)
Merging a multi-record layout4m 31s
-
(Locked)
Challenge: Creating personalized mailing1m 12s
-
(Locked)
Solution: Creating personalized mailing3m 21s
-
(Locked)
-
-
-
-
-
-
-
-
-
-