Lesson Category: Magical Picture Method

Here Is What We Will Do

Adding a unique image to each page of your Affinity Publisher file only takes four steps. (I call it an Affinity Publisher file, because it can be any thing. I’ll use monthly calendars (without the real dates) as the example file in this course.) Here they are: Step one: Gather the images. Step two: Create …

Here Is What We Will Do Read More »

Export as PDF

You need to create a PDF file, which you can sell or giveaway as you please. To do this in Affinity Publisher, you choose the menu File > Export. Check the Preflight warnings. You should be fine to go, or else correct spelling errors. On your next run, choose Ignore and continue to the Preflight warnings. …

Export as PDF Read More »

Save the New File

The first time I merged something with Affinity Publisher, I wasn’t aware that it created a new file. So I was puzzled when it asked me if I wanted to save. I messed it all up by saving under the same name as my source Affinity Publisher file. To make sure you don’t commit the …

Save the New File Read More »

Merge and See the Magic Unfold

This step is easy, because you’ve already made all the preparations. If you have closed down Affinity Publisher and the file you were working on, then open it again. If you’re using the workshop file, you should now see something like this: You should look for the surefire sign that an image field had been …

Merge and See the Magic Unfold Read More »

Why This Is Step Four

While some of the other steps can be switched out… there’s no arguing about this one. This is the final step, and it can only be done at this point, when you have: Gathered your images in one folder. Created the spreadsheet and added links (paths) to your images. Made room for the images in …

Why This Is Step Four Read More »

Add Fields

Alternative link to video We need a way to tell Affinity Publisher where it should put the images from the spreadsheet. And we do that by adding fields. That is also easy and fun. This is how you do it: With your Affinity Publisher file open, and with the spreadsheet connected, go to the menu View …

Add Fields Read More »

Connect With Your Spreadsheet

In this lesson you’re going to connect your Affinity Publisher file with your spreadsheet. It’s easy and fast. You’ll see. This is how you do it: Open your Affinity Publisher file. If you’re using the work file I offered then the file name is: MonthlyWithoutDatesForExercises.afpub (and you’ll find it in the first lesson of module …

Connect With Your Spreadsheet Read More »

Make Room for Images

Whether you picked up the file I provided, or you have your own Affinity Publisher file, you’re now ready to make room for the images. We do that in one place… one place that will allow us to add images to all the pages we’re going to create from this file. Do you know where …

Make Room for Images Read More »

Why This Is Step Three

Let’s see what we have so far: We have images. Check. We have a spreadsheet with links to the images on our computer. Check. This is the next step: Make our Affinity Publisher file ready for the images. You need a file to work with. If you already have one, that’s fine. Here I’ll give …

Why This Is Step Three Read More »