Help building mailing lists / labels

[tinzauro]

Good morning list.

I have been trying to create some mailing list / labels from data stored in the contacts table within sugar, but I am struggling horribly.

This is how I'd like to see the label:

<firstn_name> <last_name>
<account_name>
<primary_address_street>
<primary_address_city>, <primary_address-state> <primary_address_postalcode>

I was able to perform the following query on the accounts table, but I want to be able to be able to perform the query on the contacts table. Unfortunately, I don't know how to pull the related <account_name> data in from the accounts table.

#SELECT `leads`.`first_name` AS `FIRST`, `leads`.`last_name` AS `LAST`, `leads`.`account_name` AS `COMPANY`, `leads`.`primary_address_street` AS `STREETADDRESS`, `leads`.`primary_address_city` AS `CITY`, `leads`.`primary_address_state` AS `STATE`, `leads`.`primary_address_postalcode` AS `ZIP` FROM `prod_has_sugarcrm520`.`leads` AS `leads`;

Is my problem a matter of designing the correct sql query or am I going about this the wrong way. Thank you for any help available.

[tinzauro]

On a related note, I am using Open Office Writer (with an Open Office Base SQL connection) to create the labels. It is my intention to continue to use this method as it is easily to migrate/port the solution to office workers and or marketing helpers.

A full write up on the process will be posted here once completed.

[crm2office]

Are you using Microsoft Word? If so try the CRM2Word plugin from CRM2Office. It connects to your Sugar system and produces labels and mail merge documents
http://crm2office.com/sugarcrm-relat...rm2msword.html

[tinzauro]

No, I am not using Word. I am using Open Office.

[christianknoll]

You can use our reporter to produce an xls with that information and then use that in a word document to produce your labels. the reporter is still beta but you can find it at http://www.sugarforge.org/projects/kinamureporter/ .. a tools available under GPL (at least the basic version but that will satify your need) ...

regards, christian.

http://www.kinamu.com

Good morning list.

I have been trying to create some mailing list / labels from data stored in the contacts table within sugar, but I am struggling horribly.

This is how I'd like to see the label:

<firstn_name> <last_name>
<account_name>
<primary_address_street>
<primary_address_city>, <primary_address-state> <primary_address_postalcode>

I was able to perform the following query on the accounts table, but I want to be able to be able to perform the query on the contacts table. Unfortunately, I don't know how to pull the related <account_name> data in from the accounts table.

#SELECT `leads`.`first_name` AS `FIRST`, `leads`.`last_name` AS `LAST`, `leads`.`account_name` AS `COMPANY`, `leads`.`primary_address_street` AS `STREETADDRESS`, `leads`.`primary_address_city` AS `CITY`, `leads`.`primary_address_state` AS `STATE`, `leads`.`primary_address_postalcode` AS `ZIP` FROM `prod_has_sugarcrm520`.`leads` AS `leads`;

Is my problem a matter of designing the correct sql query or am I going about this the wrong way. Thank you for any help available.