I am new to Access and have always wanted to learn it. I usually learn from getting something that already exists and taking it apart and seeing how it works. I downloaded a simple call center template from the MS site (http://office.microsoft.com/en-us/templates/TC102068791033.aspx?CategoryID=CT101428241033&av=ZAC000
) I have changed everything around to where I like it, but when I want to send an email to the client it sends the email to the tech and not the client. I can't figure out why I can't get it to go find the emails address that goes with the customer. Here is the line that I am working with.
To: =DLookUp("[E-mail Address]","Customers","[ID
]=" & Nz([E-mail Address],0))
Any recommendations on what I can change to make it work would be appreciated.