FrontAccounting forum — export clients addresses to a .csv file

Re: export clients addresses to a .csv file

2021-10-04T21:15:47Z

To save the next person some mental gymnastics, the following query worked for me:

SELECT `name`,email FROM crm_persons where id IN (SELECT person_id FROM crm_contacts WHERE type='customer');

I think most people will have to set

type='cust_branch'

, but should be easy enough to figure out how to modify the statement for your own system.

Re: export clients addresses to a .csv file

2015-06-25T02:40:02Z

Checkout the ERDs in the FA Wiki.

export clients addresses to a .csv file

2015-06-22T20:24:25Z

I am new to the accounting industry. I have been given a task to write send letters to our clients.
I would like to know how i can export clients address to a a .csv, so that i can do a mail merge and send letters.
Please help.

thanks