Does anyone know if you can send an email from Access using the stationary set in outlook.
I have a form that sends the email but it only opens a blank email, it would be great if it opened using our company stationary
Here is the code for the send button, it also adds an attachment to the email from info in the database also - Private Sub cmdSendMail_Click()
-
-
'Provides the Send Mail automation
-
-
Dim oLook As Object
-
Dim oMail As Object
-
Dim olns As Outlook.NameSpace
-
-
-
Set oLook = CreateObject("Outlook.Application")
-
Set olns = oLook.GetNamespace("MAPI")
-
Set oMail = oLook.CreateItem(0)
-
-
With oMail
-
-
If IsNull(Me.LblUserName.Value) Then
-
MsgBox "You cannot send email to no-one!", vbCritical, "Email Sending Error"
-
Exit Sub
-
End If
-
-
.To = Me.LblUserName.Value
-
-
If IsNull(Me.EmailMessageBox.Value) Then
-
MsgBox "You did not enter any content in the Email Message Body. Sending has been aborted.", vbCritical
-
Me.EmailMessageBox.SetFocus
-
Exit Sub
-
End If
-
-
.Body = Me.EmailMessageBox.Value
-
-
-
If IsNull(Me.EmailSubject.Value) Then
-
MsgBox "Please provide a subject for this email", vbExclamation, "Empty Subject Field"
-
Exit Sub
-
End If
-
-
.Subject = Me.EmailSubject.Value
-
-
' Evaluate full filepath from link
-
-
LenFile = Len(Forms!Results.File.Value)
-
Forms!Results.filetxt.Value = Mid(Forms!Results.File.Value, 2, LenFile - 2)
-
-
.Attachments.Add Forms!Results.filetxt.Value
-
-
-
If Me.PreviewSender.Value = 2 Then
-
.Display
-
Else
-
.Send
-
MsgBox "Email sent successfully"
-
DoCmd.Close acForm, "Email Options"
-
End If
-
-
-
End With
-
Set oMail = Nothing
-
Set oLook = Nothing
-
-
Forms!Results.Command8.SetFocus
-
-
End Sub
Thanks
0 1395 Sign in to post your reply or Sign up for a free account.
Similar topics |
by: TLMM |
last post by:
I have an HTML page which is a newsletter. I want to be able to add it to an
email message so I can email it to people. I want it to be in the body of
the email, not sent as an attachment.
There is a .htm page, several images, and a .css page. I need all of these
to be embedded for the page to work correctly. I can put the styles from the
..css file into the html page, but I still need to know how to embed the
images.
I tried creating...
|
by: Mike |
last post by:
Is there a way to determine what a user's default email client is? I
read a post from 3 years ago that said no. I guess I'm hoping
something has come along since then.
|
by: DaveF |
last post by:
Is it possible to keep the header stationary and scroll the data? Without
buying something
|
by: Mads Westen |
last post by:
Hi,
I got some code working to create a new mail in Outlook and displaying it.
I'm currently using the "Outlook._MailItem".
I want to be able to use the standard stationary, which is set up in
Outlook. (The one Outlook uses as default, when hitting the "new mail
button").
Is there a way to do that, or can I only create text mails?
|
by: spdas |
last post by:
Aloha, I would like to show one field (textbox), that represents an
inventory item and have 200-300 of these fields on a page.
1: I want to stay in the form format and not report as I want to use
mouseovers
2: Each Textbox would be one large inventory item and I will be adding
or subtracting daily and would like to arrange them on a form or map.
3: I have done this before but with stationary inventory and it was a
| |
by: Eran.Yasso |
last post by:
Hi,
Can i cause scrollbars to be activate only on part of the form?
Meaning"
I have buttons in top of form which i don't want scrollbars to scroll
this button. I want this button to be available even if acroll bars are
activated.
|
by: tpgames |
last post by:
You know how some pages has a stationary image, but the text can move over the image when the user scrolls down the page? I don't know what to put in the search box to find this code. I keep finding the scrolling text codes! Is the image not really stationary? (I thought the script used JS).
Thanks!
It's funny how when I want this code, I can't find it, but when I don't want it, I keep finding examples of this on many a web page. LOL
|
by: mayankaswal |
last post by:
I am using a DataList and I have used a PlaceHolder to generate the Headers and Items. The problem is when the items list is big and I scroll down, the header also moves. I am trying the header to be stationary. I am using the following code:
<asp:UpdatePanel ID="pricingUpdatePanel" runat="server">
<ContentTemplate>
<table width="600">
<asp:DataList ID="pricingDataList" runat="server" OnItemDataBound="pricingDataList_ItemDataBound"...
|
by: swaroopgadekar |
last post by:
Please tell me how can i print the selected text matter of a crystal report in WINDOWS APPLICATION, on a pre printing stationary
EX:
---------------------------------------------------------------------------------------------
SWAROOP INDUSTRIES LIMITED
dhankawadi, Pune. ...
|
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: 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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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: 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...
| |