Send Object Method from Table Field
Posted on 2009-05-03
I have an Access Database that has a main table and a form that users use to enter data into the main table. There is also a second table that contains customer names. The first control on the form is a combo box that is bound to the customer field in the second table so users can select uniform spellings for customer names that will write to the main table also. This second table contains another field besides the customer name which is the customer's email address. The db also has a report that is based on the main table. What I want to do is to use the SendObject method to email the report to the customer for his specific record by using the customer's email address in the second table. I want the user to be able to avoid having to type in the customer's email address for each report sent out by using the email address in the second table. Is this possible? If so, how would I do it? It seems that the To: attribute in the SendObject method does not recognize any table or field reference.