Outlook CRM Address: Difference between revisions
From Accelerator for SageCRM
(Created page with "Now 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) ...") |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
On the NEW Mail, Task and Appointment screens you will see an Address Book button. | |||
[[File:addressbook1.png]] | |||
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. | 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. | |||
[[File:addressbook2.png]] | |||
---- | |||
Example of the SQL run to get the data for this address book ('frank' would be the search value entered in the filter) | |||
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%' | |||
Latest revision as of 17:17, 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 ('frank' would be the search value entered in the filter)
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%'
