Solved

Send Object Method from Table Field

Posted on 2009-05-03
5
303 Views
Last Modified: 2013-11-29
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.
0
Comment
Question by:Ennistymon
  • 3
  • 2
5 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24292803
Ennistymon,

Here you go.

Study it carefully.
I am sure you can adapt this to work in your database.

;-)

JeffCoachman
Access-BasicSampleEmailIndividua.mdb
0
 

Author Comment

by:Ennistymon
ID: 24298258
Jeff, thank you for your thorough answer to my question. The user will send the email after each record is entered. What kind of changes to the code would be needed to accomplish this?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
ID: 24298964
0
 

Author Closing Comment

by:Ennistymon
ID: 31578316
Jeff,
I am continuing to study and work with your solution particularly the last update which I believe will ultimately solve my problem. My limited knowledge of VBA and SQL are making this task daunting and time consuming, but I believe I am now on the right track with your help. Thanks for your help.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24311757
;-)

Thanks.

Do a search on Amazon for good Access and SQL reference books.

Good Luck!
;-)


Jeff
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question