473,670 Members | 2,599 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

email form using stationary

347 Contributor
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

Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdSendMail_Click()
  2.  
  3. 'Provides the Send Mail automation
  4.  
  5. Dim oLook As Object
  6. Dim oMail As Object
  7. Dim olns As Outlook.NameSpace
  8.  
  9.  
  10.     Set oLook = CreateObject("Outlook.Application")
  11.     Set olns = oLook.GetNamespace("MAPI")
  12.     Set oMail = oLook.CreateItem(0)
  13.  
  14.     With oMail
  15.  
  16.     If IsNull(Me.LblUserName.Value) Then
  17.     MsgBox "You cannot send email to no-one!", vbCritical, "Email Sending Error"
  18.     Exit Sub
  19.     End If
  20.  
  21.     .To = Me.LblUserName.Value
  22.  
  23.     If IsNull(Me.EmailMessageBox.Value) Then
  24.     MsgBox "You did not enter any content in the Email Message Body. Sending has been aborted.", vbCritical
  25.     Me.EmailMessageBox.SetFocus
  26.     Exit Sub
  27.     End If
  28.  
  29.     .Body = Me.EmailMessageBox.Value
  30.  
  31.  
  32.     If IsNull(Me.EmailSubject.Value) Then
  33.     MsgBox "Please provide a subject for this email", vbExclamation, "Empty Subject Field"
  34.     Exit Sub
  35.     End If
  36.  
  37.     .Subject = Me.EmailSubject.Value
  38.  
  39. '  Evaluate full filepath from link
  40.  
  41.     LenFile = Len(Forms!Results.File.Value)
  42.     Forms!Results.filetxt.Value = Mid(Forms!Results.File.Value, 2, LenFile - 2)
  43.  
  44.     .Attachments.Add Forms!Results.filetxt.Value
  45.  
  46.  
  47.     If Me.PreviewSender.Value = 2 Then
  48.     .Display
  49.     Else
  50.     .Send
  51.     MsgBox "Email sent successfully"
  52.     DoCmd.Close acForm, "Email Options"
  53.     End If
  54.  
  55.  
  56.     End With
  57.     Set oMail = Nothing
  58.     Set oLook = Nothing
  59.  
  60.     Forms!Results.Command8.SetFocus
  61.  
  62. End Sub
Thanks
Aug 15 '08 #1
0 1395

Sign in to post your reply or Sign up for a free account.

Similar topics

7
7123
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...
88
12476
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.
1
1084
by: DaveF | last post by:
Is it possible to keep the header stationary and scroll the data? Without buying something
0
1051
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?
6
1373
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
2
1812
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.
2
1161
tpgames
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
3
1857
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"...
0
1083
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. ...
0
8468
marktang
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...
0
8386
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,...
0
8901
Oralloy
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...
0
8660
tracyyun
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...
0
7415
agi2029
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...
0
5683
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();...
0
4390
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2799
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
2
1792
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.