Solved

Send Object Method from Table Field

Posted on 2009-05-03
5
305 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 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