D365 Finance & Operations and Dynamics AX Forum

 View Only
  • 1.  Need a list of tables where Email Addresses are stored in AX 2012

    TOP CONTRIBUTOR
    Posted Apr 15, 2022 12:46 PM
    Edited by Rudy Salcedo Apr 16, 2022 08:24 AM
    We'll be replacing our Email software sometime this year and we need to update employee email addresses that are stored in  AX 2012 R2 tables.  Basically we need to replace employee email addresses that are in the current format that uses the employee's initials with an email address in FirstName.LastName format.

    So far we know that the LogisticsElectronicAdress and SysUserInfo tables store email addresses, and we're in the process of writing code to update the employee email addresses in those tables.

    I've also generated a list of customers whose Print Management settings indicate that their sales invoice should be mailed to one of our employees.  Someone in our A/R dept will manually update the email addresses.

    In what other tables in AX 2012 R2 are email addresses stored?  Thanks in advance.


    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------


  • 2.  RE: Need a list of tables where Email Addresses are stored in AX 2012

    GOLD CONTRIBUTOR
    Posted Apr 18, 2022 01:14 PM
    I think that there's quite a lot of tables.  You can start by searching the AOT with "type:"Extended data type" email".  Fortunately they're not all String.  Pick an EDT (like "Email") and right-click "Find references" and look for "dynamics://Table/.../FormStringControl".

    ------------------------------
    Steeve Gilbert
    Software Development Supervisor
    Boa-Franc S.E.N.C.
    QC, Canada
    ------------------------------



  • 3.  RE: Need a list of tables where Email Addresses are stored in AX 2012

    TOP CONTRIBUTOR
    Posted Apr 20, 2022 03:38 PM
    Thanks for the suggestions @Steeve Gilbert , I'll give that a try!​

    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role