Data Merge a Vertical Weekly Layout in Affinity Publisher

In this video, I’ll walk you through how to data merge a Vertical Weekly Planner Layout with your source data in Affinity Publisher. The layout we're using was created in a previous tutorial. If you missed that, I recommend checking it out before or after this video: You'll find that video at    • Create a Vertical Weekly Planner Layo...   We’ll focus on merging key information like dates, days, and holidays (or other special events) into the planner layout. I’ll show you how to connect your Excel file to Affinity Publisher using the Data Merge Manager and how to format and automate dates in Excel for the merge. This ensures you have full control over how your data appears, no matter which system settings or regional formats you use. 🎓 Here’s what you'll learn: 1. How to connect your data source to Affinity Publisher 2. Formatting dates in Excel to work seamlessly with Affinity’s Data Merge 3. Using the Text function in Excel to ensure consistent date formats 4. Adding placeholders for your data in Affinity Publisher and configuring the layout for multiple days 5. How to manage multiple pages and preview your layout before completing the merge 6. Using symbols to maintain flexibility and make easy edits to your layout even after the data merge By the end of this tutorial, you'll know how to fully automate the process of adding dates, days, and holidays into your planner layout, leaving you with a ready-to-use, customized weekly planner. 🧰 Free Resources - October Twilight Font | dafont.com: www.dafont.com/october-twilight.font 👍 Like, Share, and Subscribe for more Affinity Publisher tips and tricks. Drop your questions or suggestions in the comments below – I love hearing from you! 💌 Want more free training? Check out: elainegiles.com/vip ❤️ Connect with me, I love to hear from you! ✍️ Blog: elainegiles.co.uk/ 🎬 YouTube: youtube.com/ElaineGiles?sub_confirmation=1 🐦 Twitter: twitter.com/elainegiles 📸 Instagram: www.instagram.com/elainegiles 🔗 LinkedIn: uk.linkedin.com/in/elainegiles 🟦 Facebook: facebook.com/elainegiles 🧵 Threads: www.threads.net/@elainegiles 🦋 Bluesky: bsky.app/profile/elainegiles.bsky.social 🐘 Mastodon: mastodon.social/@ElaineGiles #affinitypublisher #datamerge #plannerpages

• #education
• #affinity_publisher
• #affinity_publisher_tutorial
• #affinity_publisher_2
• #data_merge
• #graphic_design_tutorial
• #how_to_use_data_merge
• #affinity_publisher_data_merge
• #data_merge_affinity_publisher
• #planner_pages_ideas
• #diy_planner_pages
• #daily_planner_pages
• #design_planner_pages
• #decorate_planner_pages
• #weekly_planner_ideas
• #weekly_planner_setup
• #weekly_planner_layout