Hi, I was wondering if anyone could help me with a really stupid problem. I have a form (special pricing) in access where I want to be able to email the person named in a particular field.
The problem is, that in the SendObject macro, I can't seem to get the code right simply to look up the email address field from the sales rep table.
Where am I going wrong? Should I even be using DLookup? I'm beginning to wonder, please help me!!!!
Thanks
Holl

What error are you getting? You should be able to include the email address on the form (if you don't want your users to see it, then just hide it). You should then be able to get the button to email the user without another lookup trip.