Prev: Code no longer works
Next: Updating Form VS Not Updating Form
From: NEED TO KNOW NEED TO on 18 Dec 2009 12:38
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.
From: Daniel Pineault on 18 Dec 2009 14:51
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.



"NEED TO KNOW" wrote:

> 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.
 | 
Pages: 1
Prev: Code no longer works
Next: Updating Form VS Not Updating Form