18 Replies Latest reply on Apr 10, 2018 9:45 AM by Laubender

    Data Merge creating blank pages for empty spreadsheet rows

    amyd78996727 Level 1

      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!