Solved

Send Object Method from Table Field

Posted on 2009-05-03
5
300 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
Comment Utility
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
Comment Utility
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
Comment Utility
0
 

Author Closing Comment

by:Ennistymon
Comment Utility
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
Comment Utility
;-)

Thanks.

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

Good Luck!
;-)


Jeff
0

Featured Post

Backup Your Microsoft Windows Server®

Backup 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.

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now