Hi,

I'm working with Sugar Enterprise v5.1.0

I try to extract the first address of the recipients list from each mail of a bunch imported with the Outlook plugin.

When I'm requesting the EMAILS_EMAIL_ADR_REL table, the IDs of the addresses stored in EMAIL_ADDRESSES which are returned aren't in the correct order, i.e. the order the addresses are displayed when I'm visualizing the mail from within Sugar.

I then thought that Sugar could display the content of the 'to_addrs' field of EMAILS_TEXT, but this field is empty for any and each record of the table!

So is my question:
How/where can I find the displayed order of the recipients of an email ?

Thanks in advance for any help.
Greetings,
Dji