Solved

How can we run a Dynamics CRM 2013 Advanced Find query to return ALL contact email addresses for accounts that match certain criteria?

Posted on 2014-04-24
6
1,801 Views
Last Modified: 2014-05-01
Forgive me if the answer to this question is staring me in the face, but I've spent the better part of the day looking for a solution and haven't found one yet. I will try to explain this as clearly as possible.

We have a client that is rolling out Dynamics CRM 2013, and we want to pre-create some dynamic marketing lists for staff to email large groups of contacts at once. On the Account level, we have several custom fields defined, which we want to use to filter down the pool of accounts. For example, one custom field is "Current Status," and includes one option of "Board Member." In this organization, board members and their family members all have individual contact records associated with their account. What we want to do is create a dynamic marketing list that includes email addresses for ALL of the contacts that exist for any accounts that match the current status of "Board Member."

When we go to specify these criteria in the "Select Members" screen of the marketing list, it seems we can only choose to search for Account criteria that apply to the Primary Contact. In other words, the "Related" categories only includes "Account (Primary Contact)." We're able to select the Current Status value we want, but then the query only returns the email address of the primary contact. We want to return the email addresses of all contacts affiliated with the accounts that have a current status of Board Member.

I hope this is clear, but please feel free to ask follow-up questions and I'll answer to the best of my ability. I apologize in advance, as I'm not a Dynamics expert by any means. Thanks!
0
Comment
Question by:bluekeytechnology
  • 3
  • 3
6 Comments
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 40020938
Try this, in the related section of the query look for Parent Customer (Account) . Then you should select the custom field criteria as needed.
0
 

Author Comment

by:bluekeytechnology
ID: 40021266
Unfortunately, Parent Customer (Account) isn't an option. The only thing relating to the account at all is Account (Primary Contact).
0
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 40022639
Can you confirm the member type for your Marketing List. I was thinking it is contact.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:bluekeytechnology
ID: 40022652
Yes. When creating the marketing list, we're targeting Contacts as the member type. For whatever reason, though, our only option is to choose Account (Primary Contact). And when we do that, we get access to all the fields we want to sort accounts on, but it only returns primary contact records...not all records.

I am guessing that somehow we need to add a new relationship between accounts and contacts in some way, but I'm out of my league on how to appropriately do that to accomplish the goal.
0
 
LVL 29

Accepted Solution

by:
Feridun Kadir earned 500 total points
ID: 40023086
No you do not need to create a new relationship.  I think the problem is that I forgot in CRM 2013 the linking field from Contact to Account is called Company Name. So you need to look for Company Name (Account).
0
 

Author Closing Comment

by:bluekeytechnology
ID: 40036102
Feridun, thanks for sticking with me through all of that! I knew it had to be an extremely simple solution, I just wasn't connecting the Company Name field logically so I was ignoring it. Thanks!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question