Outlook CRM Address: Difference between revisions

From Accelerator for SageCRM
No edit summary
No edit summary
Line 7: Line 7:


[[File:addressbook2.png]]
[[File:addressbook2.png]]
----
Example of the SQL run to get the data for this address book
  SELECT top 25 * from vAcceleratorEmail WITH (NOLOCK) where
                pers_firstname like '%frank%'
                or pers_lastname like '%frank%'
                or pers_fullname like '%frank%'
                or emai_emailaddress like '%frank%'

Revision as of 15:16, 16 May 2016

On the NEW Mail, Task and Appointment screens you will see an Address Book button.

This button opens a CRM address book dialog. Type on this and click "Go" (or hit return) and the system will search CRM returning the top 25 results from your CRM system.




Example of the SQL run to get the data for this address book

 SELECT top 25 * from vAcceleratorEmail WITH (NOLOCK) where 
                pers_firstname like '%frank%'
                or pers_lastname like '%frank%'
                or pers_fullname like '%frank%'
                or emai_emailaddress like '%frank%'