I know none of the usual customer/invoice reports will do what you want, but I suspect exporting the invoices instead of printing them might work - and I've just fired up my Windows laptop (very rarely do I do that at home!) and experimented, and I think you're in luck - at least, this seems to work for me. Try it with a small batch first, just in case.

Select the batch of invoices, then click on the print (not quick print) icon on the toolbar. Select the invoice layout, and instead of printing, choose export (just the standard export, NOT export to Excel). Change the 'Save as type' to CSV, choose a filename, then save.

If you load the newly saved CSV file into a spreadsheet, you should hopefully see it's saved it as a line per invoice (whereas the Excel option would've laid it out to resemble an invoice). If they've been consistent with that address format you describe, the phone numbers *should* all be in one column. (You'll probably find the columns intermixed slightly - depending on the actual layout for invoices. (Here for example, A is 'Invoice' or 'Credit Note', B is the company name, C the account reference, D the first line of the address, E the date, F the second line of the address, and so on).

You could probably create a new layout that contains not much more than the address panel, and thus reduces the clutter in the CSV file - might speed things up slightly.

As for having that one customer account, I have a client set up similarly (my choice, not theirs). In their case, it's two accounts, one for B2B sales, one for B2C sales. (This happens to be the one I've mentioned before for whom I wrote an invoicing program).

Vince - what a life saver! Going to give this a try later today at my clients.

Thank you, you star.

hi Ian, long time no see!