GP listing of Employee e-mail addresses by address

[Brynne]

Does anyone know how I can get an employee email listing by address, i.e.
employees have address IDs of primary, work, etc. The only thing I found
that comes close to getting e-mail addresses is in KB949662

[Mariano Gomez]

You can create such listing in SmartList Builder by using the following query
as a base:

SELECT A.Master_ID, B.FRSTNAME, B.LASTNAME, B..., A.INET1 AS email
FROM SY01200 A INNER JOIN UPR00100 B ON (A.Master_ID = B.EMPLOYID)
WHERE A.Master_Type = 'EMP'
ORDER BY A.ADRSCODE, A.Master_ID

The 'B...' represents any other fields that you may want to display or pull
into your query from the Employee Master table (UPR00100).

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com

Post by Brynne
Does anyone know how I can get an employee email listing by address, i.e.
employees have address IDs of primary, work, etc. The only thing I found
that comes close to getting e-mail addresses is in KB949662
--
Brynne

[Brynne]

And if we don't have SLB?
--
Brynne

Post by Brynne
Does anyone know how I can get an employee email listing by address, i.e.
employees have address IDs of primary, work, etc. The only thing I found
that comes close to getting e-mail addresses is in KB949662
--
Brynne

[Mariano Gomez]

You may still be able to leverage the query with a Crystal Report or SSRS
report.
--
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com

Post by Brynne
And if we don't have SLB?
--
Brynne

Post by Brynne
Does anyone know how I can get an employee email listing by address, i.e.
employees have address IDs of primary, work, etc. The only thing I found
that comes close to getting e-mail addresses is in KB949662
--
Brynne

[Jim Hummer]

Post by Brynne
And if we don't have SLB?
--
Brynne

Post by Brynne
Does anyone know how I can get an employee email listing by address, i.e.
employees have address IDs of primary, work, etc.  The only thing I found
that comes close to getting e-mail addresses is in KB949662
--
Brynne- Hide quoted text -

- Show quoted text -

You can do the view in SQL and then copy and paste the results to
Excel or use MS Query.

Jim

[Brynne]

Thanks, I tried this and received one e-mail per employee back. What if I
want the different address IDs and corresponding e-mails? Such as address ID
PRIMARY has ***@microsoft.com and address ID HOME has ***@comcast.net?
--
Brynne

Post by Jim Hummer

Post by Brynne
And if we don't have SLB?
--
Brynne

Post by Brynne
Does anyone know how I can get an employee email listing by address, i.e.
employees have address IDs of primary, work, etc. The only thing I found
that comes close to getting e-mail addresses is in KB949662
--
Brynne- Hide quoted text -

- Show quoted text -

You can do the view in SQL and then copy and paste the results to
Excel or use MS Query.
Jim