Solved

Send Object Method from Table Field

Posted on 2009-05-03
5
304 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

730 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