Ok, I have a db that I enter a different email address into each record as I create it. I want the option to send a pre-created email to the email address in that one record by simply clicking my run nacro button. I used sendobject to get it going and have everything I want, except one thing. I need the email address to fill in the To: portion of the sendobject macro when I click the button to run the email macro. Under the sendobject option, I have my CC: filled with my address, the subject and body I want, but am not sure how to get the CustomerEMailAddress field to automatically fill in the To: section for the record I want to send an email from.
I don't use macros, but in VBA you'd be able to refer to the form control to get the address. You might see if the "Build" option is available in that spot, which should let you navigate to the form control.
To be honest I felt I had a good handle on Access until I attempted this email macro...I'm not sure how to establish the form reference in the To. On the macro setup I had tried several methods that might have worked, but was left empty handed. I was just hoping their was a simple task of just typing something in the box that I had not thought of.