FrontAccounting forum — export clients addresses to a .csv file

Re: export clients addresses to a .csv file

null@example.com (bobloblian) — Mon, 04 Oct 2021 21:15:47 +0000

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

null@example.com (apmuthu) — Thu, 25 Jun 2015 02:40:02 +0000

Checkout the ERDs in the FA Wiki.

export clients addresses to a .csv file

null@example.com (sdirfan) — Mon, 22 Jun 2015 20:24:25 +0000

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