EatMoreBacon

Attached find templates for a birthday \ appointment calendar... A very simple basic one done only with Excel \ Libreoffice Extremely deluxe calendars designed with a data merge into Affinity Publisher. Attached are templates for monthly calendar Monthly Planner six months on one page twelve months on a large page Would be glad to hear suggestions for improvement. Thanks! DIY Birthday and Appointment Calendars.pdf Monthly Calendar template.afpub Monthly Planner template.afpub six month template.afpub twelve month template.afpub Calendar Worksheet, legacy.xlsx Calendar Worksheet, libreoffice.ods Calendar Worksheet.xlsx

Check your data merge layout settings. i suspect there are two data merges. One is going to need a -(number) in the offset to merge properly. Also check out this option...

I also found that doing a Lookup and returning actual text works. So I wonder if it has something to do with the custom formatting.

Viel Dank! That makes things clearer! Thanks a lot!

What confuses me is how does Affinity decide which Data Merge to do first? If there is more than one Data Merge Layout, the record offset has to be set to -n If i put the heading in a separate data merge (not data merge layout) can I set a record offset on that as well?

I'm frustrated. In template4, I have two data merge Layout. One is working as expected giving me the info for each date cell. The other is giving wrong values. Instead of the month and year as shown on spreadsheet, it gives 0000 2024 Instead of the Day of Week as shown on the spreadsheet, it moves all my days by one. I can find no reason for why it acts the way it does. I've double checked my formulas. I've tried pasting values (file attached). Any suggestions? Birthday Calendar template4.afpub Birthday Calendar trial.afpub Book1_exp.xlsx

If I have a Data Merge Layout for the main body of the page, can I use a separate data Merge for the heading on the page? I need 7 instances of the data Merge for the main body so I use data Merge layout. But I only want one instance of the heading...

So in any case, till the powers that be change something, I will need to use codes that I find and replace after the merge? Or is Alt 010 something that can be inserted in Excel?

When I'm doing a mail merge, Affinity doesn't seem to recognize Char 10 (line break). I also tried Char 13 which some say works on Mac (I'm on Windows), but that didn't work any better. What do I input in my spreadsheet to indicate a line break that Affinity Publisher will recognize?

Right, but each cell in excel will only go to one style in Publisher. So if I have several different styles for each N, I will need to have the same number of cells x 6 in each row of the spreadsheet. Thanks for that suggestion. I will have to think through my layout and decide what will work best. I guess it isn't possible to display a two page spread minus the margins so that the layout tool would ignore the gutter?

Ok, so basically I have to rework my spreadsheet to have all the data values for one row in my merge to be in one row in my spreadsheet. Will seem like lots of repeat cause I'm merging about 8 values to n and each value gets a different placement or different paragraph style in Publisher. But it can be done! Thanks!

but that gutter will apply to each row and column. i want three columns on the first page then a wide gutter and then three columns on the next page

When using the Data Merge layout tool - can my n-up layout span two pages? At the page gutter I need a little more space between the columns than I do otherwise. I want the merge to go row by row straight across the page break. So it would do 123 in first row on page 1, then 456 on first row on page 2, then 789 on 2nd row on page 1, etc

Thanks!

When using the data merge layout tool, I want to have a bounding box, except when certain fields are missing, I want no bounding box to appear. Is this possible?