Re: Data Merge creating blank pages for empty spre...

amyd78996727 · ‎Mar 15, 2017

Amazing! Thank you Mike. That will do the job just fine!

amyd78996727 · ‎Mar 14, 2017

Hi Mike, yes that's right. There are blank rows and sometimes blank cells where addresses don't have suburbs etc. The problem with sorting so that the blank rows are at the bottom of the spreadsheet is it makes the merged envelopes difficult for clients to check as they're the entries are now in a completely different order than what they were supplied. But it is a work around I have done in the past!

amyd78996727 · ‎Mar 14, 2017

Thanks for your reply Vinny! I will attach screenshots below. You will see in the Indd docs that the blank rows are creating a blank page. This is the CSV file I'm using… This is the pre-merge INDD document… This is page one of the merged INDD document… This is page two of the merged INDD document… Any suggestions on how I can avoid the creation of the blank pages. Like I said in my original post, i know selecting all blank cells and deleting them is an option however in the case that the addressee doesn't have a suburb that cell will be deleted moving everything under it up, therefore the rows are being confused. Does that make sense?

amyd78996727 · ‎Mar 13, 2017

I am trying to create envelopes for my stationery business. My client's provide their guests' address details in a spreadsheet which almost always contains blank cells, mainly in the State column where guests live in countries without states such as the UK and Europe. I have been told to remove the blank in Excel before merging by 'Go To / Special / Blank cells' to remove the blank cells however this causes problems as it moves all of the following information up and not keeping rows together. For example… (where / is new column) Name / Street Address / City / State / Country A Brown / 1 Two Street / London / BLANK / United Kingdom B Brown / 1 Three Street / Brisbane / Queensland / United Kingdom C Brown / 1 Four Street / New York / New York / United Kingdom Becomes… Name / Street Address / City / State / Country A Brown / 1 Two Street / London / Queensland / United Kingdom B Brown / 1 Three Street / Brisbane / New York / United Kingdom C Brown / 1 Four Street / New York / BLANK / United Kingdom How can I get Indesign to ignore those blank rows entirely so that I don't have to mess up the Excel file? I have the 'Remove Blank Lines for empty fields' option ticked however Indesign creates a blank page for every row that is blank in Excel. Please help! My frustration levels are reaching unknown heights!

amyd78996727

amyd78996727

Activity

Re: Data Merge creating blank pages for empty spre...

Re: Data Merge creating blank pages for empty spre...

Re: Data Merge creating blank pages for empty spre...

Data Merge creating blank pages for empty spreadsh...