HOW MAKE SEND OBJECT TO SEE USER PC LOGON ID FOR EMAIL ADDRESS

  • Thread starter Thread starter NEED TO KNOW
  • Start date Start date
N

NEED TO KNOW

Multiple users. Issue report button auto sends email with issue to admin.
need to know how to have copy sent to that particular user who submitted
issue --not to email address of everyone in the user table.
 
Create a cross reference table that house the user's network id and their
e-mail address.

Then you can pull the current user's network id using the code found at
http://www.mvps.org/access/api/api0008.htm

Finally, use Dlookup, Elookup or a custom query to return the network user's
name associated e-mail address and e-mail the report.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Back
Top