Email target list of all contacts of selected "Type"

[CharlieArmor]

We are trying to generate a an email target list that includes all "Contacts" who are associated with an "Account" where the account type is "Supplier"

The account definitions do not include email addresses, I need to send the messages to the associated contacts. A single supplier account may have three or four associated contacts,

I think I need to define a report that lists all the primary email addresses associated with accounts that have the type "Supplier"

I can define an SQL query to list the email addresses and then import this list back into Sugar but would prefer remain within the Sugar environment.

If anyone has come across a more elegant solution that does not require users to query the MySQL database directly I'd be very grateful for any suggestions.

Charlie Armor

[CharlieArmor]

I can't work out how to delete this thread but perhaps the solution I've come across will be of interest to someone else.

The open-source Sugar version does not appear to do quite what I require but my solution has been to install the Power Prospecting module developed by "Mr Milk"

[niche]

I have the same need, but with LEADS instead of contacts.

I used the Power Prospecting add-on to do this.
Before doing so, though, I went to the ADMIN > SYSTEM VIEW settings and changed the Listview items per page to 400.

Then I was able to assign 400 leads at a time to my target email list.
However with 3800+ leads, it was painfully slow and inefficient.

Wish there was a better way...