Data merge front and back with same record

[srdscott]

Hello,

I am trying to data merge a mailer:

• On the front I need a the customers full name and the address block.
• On the back I need the same customers salutation and a unique code.
• The csv file has the data with all fields in each column with each individual record in rows.

I have created the document and when I preview the merge the same customer is display front and back as I require.

However, when I generate the the records file the front (page 1)  has record 1 and the back (page 2) has record 2 on the new publisher file. I have tried to place the data merge layout on page 1 and 2 as well as on A-Master and B-Master to no avail.

What setting should I have on the data merge to ensure that page 1 and 2 has the same record and all subsequent records?

 

Many thanks,

Steven

[David in Яuislip]

Have a look through the attached files and try formatting the csv like this

Addresses.zip

[srdscott]

Hi David,

Thanks for reply to my question. Unfortunately this wouldn't be feasible for me as my customer supplied CSV files contain thousand of entries and I create these mailers on a daily basis.

Thank you for taking the time to look at this for me. It's very much appreciated.

 

Steven

[Old Bruce]

Here is my take on it. I really don't have any idea on what you want, I have had to guess that you want one sheet of paper with stuff on one side and some of that stuff on the second side plus one other thing.

untitled folder.zip

[David in Яuislip]

10 minutes ago, Old Bruce said:

Here is my take on it.

I was hoping you'd chime in, sadly I cannot learn your procedure as I only have V1 but have a like anyway

My final suggestion was going to be do two runs then combine the files with something like PDFSam

PDFSam.zip

[Old Bruce]

4 minutes ago, David in Яuislip said:

I cannot learn your procedure as I only have V1

Version 1 and 2.zip

And again I have to add that I really do not know what @srdscott is actually wanting. I am working on my assumption that it is a two sided sheet of paper.

[David in Яuislip]

1 minute ago, Old Bruce said:

Version 1 and 2.zip 407.88 kB · 0 downloads

Thanks, I'll go and stretch the brain

[David in Яuislip]

Wotta wombat, I didn't think of facing pages. I shall put that in my AllAbouAffinityPublishe.docx forthwith. Cheers

[srdscott]

Hi guys,

A big thank you for looking into this for me. So basically the document will be a A4 double side mailer with 3mm bleed. Side 1 with address. Side 2 with the salutation and the unique code which will be sent to the customer. I'll then take the merged pdf and impose these 2 up on and SRA3 sheet with trim marks. The imposition will happen later on other software.

I've saved a mock-up publisher file as well as the csv file for reference. I hope this makes sense. Apologies if not.

 

Sample.zip

[David in Яuislip]

16 minutes ago, srdscott said:

A big thank you for looking into this for me.

You're very welcome, however, a word of advice, if you ever post another question about about data merge wait for Old Bruce's answer and give anything by me a wide swerve

[srdscott]

1 minute ago, David in Яuislip said:

You're very welcome, however, a word of advice, if you ever post another question about about data merge wait for Old Bruce's answer and give anything by me a wide swerve

Haha not at all. I'm leaving my place of work and have used InDesign back in the days since it was called Aldus PageMaker (20 odd years). I have been seamlessly merging mailers for years but there's no way I am paying those prices for creative cloud. I've just downloaded Affinity the past two days and trying to get my head around it. I'm impressed so far. If I can nail these mailers I will be certainly buying the affinity suite.

thanks,

Steven

[lacerto]

Obsolete.