Extracting emails of contacts from a selection of accounts

[sevenprod]

Help Needed!!

How to extract emails of contacts (ie: all Sales rep) attached to a selection of accounts?

Let's say we want to massmail all the sales rep of a selection of accounts of a specific area. We first search the accounts corresponding to our geographical criteria and from the resulting selection, we want to extrat all the mail addresses of the sales contacts attached to the selected accounts.

Though this sounds like a very basic and obvious thing to do, I've been looking around for hours without any success. Am I am that dumb?

Thanks for your help!!!

[sevenprod]

Any ideas, tips, suggestions so far?

Thanks for your help

[nvdp2002]

Im trying to get similar infor from a query in zucker reports. Dont suppose youve gotten any where ?

[sevenprod]

Strangely enough, this pretty obvious issue doesn't seem to inspire many.

The only kind of way around it I've found so far while browsing though this forum intensely, is to have it done via a SQL request. I haven't been able to make it work yet, but it certainly can be done, though we're stepping miles away here from what a smooth and easy piece of software like sugar is supposed to be.

The other option I'm considering is not to create contact forms at all, but to include all contact emails of the account within the Account form itself. Since you can now enter as many email addresses as you want into the Account form, this can easily be done. The only problem with this, is that you cannot attach any extra field to the email address field (ie: a fonction field), which therefore makes impossible to select a target contact among the series of emails you have entered for an account (ie: let's say you want to massmail all Sales reps from a selection of accounts, you currently have no way to tell the system to what category of personnel the mail address is related to. From there, targeting any specific category of contacts becomes impossible).

Am I some kind of weirdie with extravagant thoughts or aren't we simply talking pretty basics here?

Please tell me!!!

[nvdp2002]

I would be ably to pull the info from zucker reports if only i new where the link between the emails and the contacts for accounts was. I cant find any key to link them together in a query. hopefull if we keep posting we will keep this at the top and some one will reply

[nvdp2002]

So........................
after many hours
this is what i find gives me as far as i can tell the correct info. This returns the first name and email. please check it and let me know if it wrong.

select email_addresses.email_address , contacts.first_name
From email_addresses
inner join email_addr_bean_rel
on email_addresses.id = email_addr_bean_rel.email_address_id
inner join contacts
on email_addr_bean_rel.bean_id = contacts.id
where email_addr_bean_rel.bean_module = 'Contacts'
and email_addr_bean_rel.primary_address = '1'
order by contacts.first_name asc

[sevenprod]

I'm not very knowledgeable in SQL queries, but thinking it over, I do not think that SQL queries can do the trick for the very issue we're talking about (which is different from your specific issue).

Step 1 of my process is selecting Accounts depending on some account specific criteria.

Step 2 => extracting the email addresses of all account related contacts (ideally, choosing which specific contacts, ie: Sales Reps) from the resulting selection of Accounts made in step 1.

Knowing that Step 1 is made within Sugar, how can I apply a SQL query to the resulting selection of accounts I have got from within Sugar in step 1? The only logical way would be to start everything from within SQL, making step 1 with SQL queries. But if the issue is to become a SQL expert in the first place, what's the need of using Sugar then?

Wouldn't it be easier for developpers to write a sugar script that could be installed and started from within Sugar?

Wouldn't that sound like an exciting thing to do the Sugar team?