<div>
To see your most recently added email addresses try this query...<br />
<br />
select top 50 contsupref,address2 from contsupp where RECTYPE = 'P' and CONTACT = 'E-mail Address' order by recid desc<br />

</div>


To see your most recently added email addresses try this query...

select top 50 contsupref,address2 from contsupp where RECTYPE = 'P' and CONTACT = 'E-mail Address' order by recid desc


<div>
Thanks, that helped us sort it.
</div>


<div>
<div class="content wysiwyg-content">
Im struggling to import an email address into the email field of the main contact &nbsp;via the GM API. We thought it was in the CONSTUPP table, but when the data is imported via the api, its not getting there.<br />
<br />
What table/field should the data go into?
</div>
</div>


Im struggling to import an email address into the email field of the main contact  via the GM API. We thought it was in the CONSTUPP table, but when the data is imported via the api, its not getting there.

What table/field should the data go into?

Where does the email table reside?

A contact manager in its most basic form is a software program that enables users to easily store and find contact information, such as names, addresses and telephone numbers. Sophisticated contact managers provide calendar sharing features and allow several people in a company to access the same database. Some contact management systems have evolved into customer relationship management (CRM) systems to analyze and plan for an organization’s interaction with current and future customers.