Hi all, i am not a programmer but a dabbler, i need to do the
following.... The user must enter on a form a monetry amount, a
project number and his name. I would like him to then click on a
button and a standard e-mail format with the inputs added to the e-
mail at certain places must be sent to a certain person, who will not
change... Any help would be appreciated.
2  2271 
"Les" <le*******@bmw. co.zawrote in message
news:11******** *************@n 15g2000prd.goog legroups.com...
Hi all, i am not a programmer but a dabbler, i need to do the
following.... The user must enter on a form a monetry amount, a
project number and his name. I would like him to then click on a
button and a standard e-mail format with the inputs added to the e-
mail at certain places must be sent to a certain person, who will not
change... Any help would be appreciated.
Check the help for the SendObject method. http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx
Keith. www.keithwilby.com
Les wrote:
Hi all, i am not a programmer but a dabbler, i need to do the
following.... The user must enter on a form a monetry amount, a
project number and his name. I would like him to then click on a
button and a standard e-mail format with the inputs added to the e-
mail at certain places must be sent to a certain person, who will not
change... Any help would be appreciated.
As Keith noted, SendObject will meet your requirements.
One of the arguments you can pass within SendObject is the EmailBody
(messagetext). You can construct some sort of message as a string for
the email body.
strBody = "Dear " & Me.FirstName & ":" & vbNewLine & vbNewLine &
"This order " & Me.OrderID & " confirms our ..."
Also, you can create a report and send the report also as an attachment.
If you do create a report, make sure the report is one where the
recordsource filters for the record you are sending the message for.
Let's say on the calling form you have a field called OrderID. Your
report should reference the OrderID on that form. Also, you will need
to save the record prior to sending the email because it really isn't a
record in the database until it is saved. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: JT |
last post by:
Hi,
I'm sure this isn't a hard one, can someone help?
I'm adding a new record to a MySQL database every x seconds. I need
to be able to inspect the content of a certain field in this incoming
record and, when a condition is met, send an email.
I suppose I could have some script inspect the latest record every x
seconds and use sendmail, but I'm unfamiliar with scripting daemons on
|
by: Lisa Pearlson |
last post by:
Hi,
My php application (on Apache/Linux) needs to do the following:
The PHP script receives a request from a client (binary), asking for certain
records of data.
My PHP script loops through all records and sends each of them ONE BY ONE.
After each record that my server script sends, it waits for the client to
confirm proper reception with an ACK (binary digit).
When there are no more records, my server script sends the client a binary
|
by: pilar |
last post by:
Hi All,
I'm using a code somebody posted here. I extract the records from a
query which gave me just the entries for the current date, there will
be maximum 5-6 entries per days and I need to send them as the body of
an email. The code partially works and what happens is that it will
send an email per every record when what I need is to send just an
email, at the end of the day, including all the entries made(Rack,
CompanyName and...
|
by: NomoreSpam4Me |
last post by:
Hi, i have a little problem: I have a form where people enter data and
when they click on the save button it saves the data then open 2 field
for my criterias and then open a rpt with that. But when i enter the
criterias all the data that i jut put in the tform r gonne to my table
and r no more visible.
exemple : I fill the form, i click save, the form moves to a new record
(blank), 2 message box open for my criterias,one i fill those 2...
|
by: moelleni |
last post by:
Hi,
I made an Access 2002 Database and wanted to automate it to sent the
current record to Word 2002. So readed the article "How to send the
current record to Word 2000 with automation" I tried to do this with my
db.
Here is my code:
Private Sub MergeButton_Click()
On Error GoTo MergeButton_Err
| | |
by: Satish |
last post by:
Hi,
I am facing problem with, sending data frm mdi child to
mdi parent.
I have search Dropdown in MDI form, depend on selection,
or enter string(its like IE URL functionality) and click
search button, i am displaying Details form with all the
details. Their i have Delete button. When we click on
delete button, we have to delete the record from database
|
by: Satish |
last post by:
Hi,
I am facing problem with, sending data frm mdi child to mdi parent.
I have search Dropdown in MDI form, depend on selection, or enter
string(its like IE URL functionality) and click search button, i am
displaying Details form with all the details. Their i have Delete
button. When we click on delete button, we have to delete the record
from database and at the same time, i have to delete record from the
drop down.
|
by: neonspark |
last post by:
I'm buidling some simple macro functionality for my app so the users can record a sequence of keyboard inputs and replay them reliably via some menu.
Originally, I used:
protected override bool ProcessCmdKey(ref Message msg, Keys keyData)
To map "Keys" objects to their string constant, and stored them on a string Queue as they were happening. Then (after resetting the form), I simulate replaying of these actions by flushing the queued...
|
by: slider |
last post by:
Hey all i am using Access 2003 on Win Xp and i have been trying to make this code send emails to the users stored on each record. So far is works, except in the body of the email i need it to say a number of things, such as Dear (user), your current quota is (quota), and so on.
So far i can send the emails to multiple users but when it comes down to writing the message i cannot enter in more than one "rec("field)".
In my database i have...
|
by: drec |
last post by:
I currently have a script together that will display one record per
page and allow the user to manually click through pages to view the
next record. How can I translate this to printing the data? I want
to be able to print the data one page at a time, but only send one
print job to do this?
I have never done this before, but would imagine it is possible.
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
