This may seem obvious to the long time user, but how does one send mail to all clients (eg promoting an open day)?

The currently available reports that list clients and details can be exported to excel for a mail merge. But they all place client first name and last name in a single cell. They also place all adddress details into a single excel cell.

Is there a report that columnates these details such that they can be easily transferred to excel for the purposes of a mail merge.

Of course, I may be going at this from completely the wrong direction! Happy to be guided.

Thanks in advance.

Peter