• Registered: 06/22/2015
  • Posts: 1

Topic: export clients addresses to a .csv file

Hi

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

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,168

Re: export clients addresses to a .csv file

Checkout the ERDs in the FA Wiki.

apmuthu's Website

  • From: Canada, Yukon
  • Registered: 09/27/2014
  • Posts: 121

Re: export clients addresses to a .csv file

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.

bobloblian's Website