I'm sending a email via Access 2000 and don't have a problem with the
basic format. What I want it to automatically grab the email of the
tech and insert it in the TO. I have a combo box which lists the
techs name and in a seperate field has the email addresses. I also
have a separate table which contains just the emails. Any
suggestions?
This is the code I'm using.
Dim strEmailBody As String
Dim strEmailBodyOne As String
Dim strEmailBodyTwo As String
Dim strEmailBodyThr ee As String
strEmailBodyOne = "Field Investigation Report " & [Forms]![New FIR
Request]![FIR Number] & " has been created for you." & vbCrLf & "This
request is for " & [Forms]![New FIR Request]![Request] & "." & vbCrLf
& "At the following intersection: " & [Forms]![New FIR
Request]![Street #1] & " and " & [Forms]![New FIR Request]![Street #2]
& vbCrLf
strEmailBodyTwo = "Please investigate this request and provide
feedback to either " & [Forms]![New FIR Request]![Name] & " or
district " & [Forms]![New FIR Request]![District] & " representative
on the results of the study." & vbCrLf
strEmailBody = strEmailBodyOne & vbCrLf & vbCrLf & strEmailBodyTwo &
vbCrLf & vbCrLf
DoCmd.SendObjec t acSendNoObject, , , , , , "New FIR Request",
strEmailBody 1 1684 ko******@earthl ink.net (Keith) wrote in message news:<8c******* *************** ***@posting.goo gle.com>... I'm sending a email via Access 2000 and don't have a problem with the basic format. What I want it to automatically grab the email of the tech and insert it in the TO. I have a combo box which lists the techs name and in a seperate field has the email addresses. I also have a separate table which contains just the emails. Any suggestions?
This is the code I'm using.
Dim strEmailBody As String Dim strEmailBodyOne As String Dim strEmailBodyTwo As String Dim strEmailBodyThr ee As String strEmailBodyOne = "Field Investigation Report " & [Forms]![New FIR Request]![FIR Number] & " has been created for you." & vbCrLf & "This request is for " & [Forms]![New FIR Request]![Request] & "." & vbCrLf & "At the following intersection: " & [Forms]![New FIR Request]![Street #1] & " and " & [Forms]![New FIR Request]![Street #2] & vbCrLf strEmailBodyTwo = "Please investigate this request and provide feedback to either " & [Forms]![New FIR Request]![Name] & " or district " & [Forms]![New FIR Request]![District] & " representative on the results of the study." & vbCrLf strEmailBody = strEmailBodyOne & vbCrLf & vbCrLf & strEmailBodyTwo & vbCrLf & vbCrLf DoCmd.SendObjec t acSendNoObject, , , , , , "New FIR Request", strEmailBody
put the e-mail address into the column with the tech's name and just
use something like
strTechEmail=cb oTech.Column(1)
to get it... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: johnnyboy10017 |
last post by:
I am having a hell of a time with what I think is a very simple query:
It won't actually insert a new record into the specified table, but
returns no error, in fact it returns "1" (or true) that the query was
successful.
Things to know:
1. id field is auto-incrementing primary key
2. Other queries SELECT, UPDATE, and DELETE all work no problem
3. INSERT works via phpMyAdmin
4. Query generated by phpMyAdmin and pasted into my PHP...
|
by: Andreas Fromm |
last post by:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
Im building an user database with many tables keeping the data for the
Address, Phone numbers, etc which are referenced by a table where I keep
the single users. My question is, how do I get the "Id"-value of a newly
inserted address to store it in the referencing user table:
|
by: Dan Keeley |
last post by:
Hi,
I've got another problem now! Getting "Input string was not in a correct
format"
I have this as my insert command:
myDataAdapter.InsertCommand = connection.CreateCommand()
myDataAdapter.InsertCommand.CommandText = _
"Insert into Suppliers " & _
|
by: mahajanvit |
last post by:
Hi one and all
I got this problem during my project. So in order to solve this I made
a very small application. I am trying to insert using SP and
sqldatasource control. I know that while using sqldatasource control,
there is no need of opening and closing a connection. Also there is no
need to write connection string. When i am selecting table from
sqldatasource and writing insert statement in C# code, its working
fine. When I am...
|
by: rn5a |
last post by:
During registration, users are supposed to enter the following
details: First Name, Last Name, EMail, UserName, Password, Confirm
Password, Address, City, State, Country, Zip & Phone Number. I am
using MS-Access 2000 database table for this app. Note that the
datatype of all the fields mentioned above are Text. Apart from the
above columns, there's another column in the DB table named
'RegDateTime' whose datatype is Date/Time which is...
| |
by: andrewtayloruk |
last post by:
I'm a newbie when it come to things php and i'm having a bit of trouble.
I'm trying to insert data from an html form into a mysql database and can't get it to work.
Just a few bits about my setup, i'm running an sql server locally, i've created the database, table and fields. I think what i'm missing is something that actually runs the sql query when i hit the submit button. Also, i'm aware i haven't made the data being inserted safe, i...
|
by: andrewtayloruk |
last post by:
Hi i was wondering if anyone could help.... I have made a little script that puts whatever a user enters into a mysql database. As well as the forms my script has an image input that uploads an image to my webserver. The thing i'm stuck on is getting the script to input the name of the file into a field in the database.
So basically the file will be uploaded and when the submit button is clicked a link to that image will be generated and put...
|
by: xzzy |
last post by:
I am writing an app that enables a user to reply to a newsgroup.
The proper syntax for From: is
"screen name" email@address.com
and over all, it should look like:
--
|
by: ctrap |
last post by:
Hi Everyone,
Here's my situation: I'm making a website for an employment agency, there is a page where potential employees can visit and "pre-register". When the submit button is hit the information is supposed to be stored in a MySQL database. Number one, when I hit submit nothing happens. I have to manually execute the PHP script. When the PHP script is executed it inserts a blank record into the database and I get my Thank You...
|
by: Betikci Boris |
last post by:
Can not insert data into SQLite3 database through browser however i
can easily insert data into my db from konsole, in both attmpts i used
php 5.2.6 on 2.6.25.* linux kernel
i think there is a problem with my php setup but i could not find
it...
here is the code;
----------------------------------------------------------------------------------------
$db = new PDO("sqlite:bar.db");
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |