Email: auto populate "TO"
Thank you for taking the time to report an issue.
What's wrong... Please write below.
ID (an auto field)
Once the fields are filled in I want to click send (a command button located on the form) and the Note to field will populate the email address in anew outlook email, the re field will populate the subject line, and the message field will populate the body of the email.
I prefer this than sending an object, but if this is not possible may have to resort to sending the object.
DoCmd.SendObject , , , "firstname.lastname@example.org", , , "Onboard Notice", msg, 0
But before it sends I get a pop-up from Outlook that reads "A program is trying to access e-mail addresses. do you want to allow this? ."
My idea is that a set of queries will populate a"e-mail"-form and from there the user should have the option to Send the email, thus also creating a timestamp of this event. The email body is a"template" were"placeholders" should accommodate selected data. The email will accommodate 2 default attachments and one to be selected by each user. Ideally the"From" field should include a generic email address related to our"collective email-box".
I have a form. One of the fields on the form is "NCRnumber" which is auto generated. I have another Field called "CARnumber" which is empty field. I want to put a button next to the "CARnumber" that will call the CARform to add a NEW CARform Record but I want to pass the "NCRnumber" from the NCRform to the "NCRNmuber on the CARform. The CARform will auto generate a "CarNumber" then return back to the NCRform and populate the "CARnumber" from the CARform
I have two tables:
tblMailing has the customer information with a unique id field "FI_Code". This database is imported monthly.
tblSurvey has about 25 survey fields that will link to the tblMailing database by an "FI_Code".
I need to create a form where the user types in the "FI_Code" and it will auto populate some fields from the "tblMailing" table, and also show the BLANK survey fields from "tblSurvey"
Need to be able to fill out the survey based on the "FI_Code" and have it saved back to "tblSurvey"
Example: Combo Box Selection is "Prospect " and Text Box value would auto populate to "Opportunity"
or: Combo Box Selection is "Client " and Text Box value would auto populate to "Clients"
The Combo Box is named "Contact_Type" and the Text Box is named "Category"
Basically I'm looking for an Expression or VBA Code that can do this..
I want to have a field (field 3) auto-populate based on what is entered into two other fields (field 1 & field 2).
Field 1 is a date field (when a presentation is due). Field 2 is a yes/no checkbox (if checked, it means no presentation is necessary). Field 3 would be a calculated text field (?) because text cannot be entered into Field 1.
If field 1 is null and field 2 is checked, then I want "NA" to auto populate into field 3. However, if field 1 is null and field 2 is not checked, I want "TBD" to auto populate into field 3. If field 1 is not null, then I want field 3 to be null
So basically, I want to email a report I'm generating in Access to someone but putting the report into the body of the email, After looking through theseforums, I found the following thread which was really useful on getting the basics done:
This is the code I've skilfully copied and pasted into my Access db:
So the above code correctly creates an email and populates the "To" and "Subject" fields fine. However, when it goes to populate the body of the email, this is what I get:
It's not replicating the layout of the report in the body of the email. It just seems to be giving me a load of rubbish instead!
I've also tried changing the ".body" to ".
I need to send an email from Access 2007. I want to use an HTML file that is located at F:\Orbits Training Doc.html as the template for the email.
The subject line needs to be "Orbits Web Training"
I have a qry that is called myemailaddresses in which I need to use field "email" to populate the email address in outlook. The field will only have 1 result and not multiple.
If it makes it easier I could also use a .txt file as the body of the email but the HTML file is much cleaner as this is a communication that will be going out to customers