Received the following error when clicking the command button to send the form in XLS format to recipients:
"The expression On Click you entered as the event property setting produced the following error: User-defined type not defined.
* The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro"
Here is the Code that I used: - Private Sub Command_Click() .
-
DoCmd.SendObject acSendForm, "myForm", acFormatXLS, "someone@somewhere.com", , , _
-
"Email with attached report", "This is the email body.", True
-
End Sub
Looking for assistance in figuring out what I need to change in order to get this to work. I am using Access 2007-2016 (not my choosing). Thank you!
1  12053  NeoPa 32,566
Recognized Expert Moderator MVP
Hi CRAZImat.
Welcome to Bytes.com.
It looks like you've missed out a comma (,) from your invocation of the method (SendObject). You appear to have set the [Bcc] parameter to what looks like it might be your [Subject], and thus set [EditMessage] to True. It probably won't like that ;-)
I should add that using positional parameters for methods with a complex list of parameters is not generally advisable. Named parameters makes much better sense (in such cases) and leads to far fewer problems.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: toufik toufik |
last post by:
I've the folowing error "Call to undefined function: phtmldec() " when using
a script encrypted with PHTML
Here are the steps done:
- I've Appache (windows XP), PHP434
- using PHTML, I've created a SELF DECODABLE SCript, it ceated me one file
having the same name.
- When I executed it for the first time, i has an error "library required
....phtmlenc4.3.4.dll"
- I've copied the file phtmlenc4.3.4.dll (is it the same than
|
by: Andrew James |
last post by:
Gentlemen,
I'm running into a problem whilst testing the parsing of a language I've
created with TPG . It seems that for some reason, TPG balks when I try
to parse an expression whose first letter is 't' (or, in fact, at any
time when 't' is at the beginning of a token). This doesn't happen with
any other letter (as far as I know), nor if the 'T' is capitalised.
My grammar looks like this:
|
by: Dermot O'Loughlin |
last post by:
Can anyone help me with this?
I get the following error when using the odbc adapter wizard in VS.Net
2003:
---------------------------
Wizard Form
---------------------------
An unexpected error has occurred.
|
by: Charlie |
last post by:
Hi:
I get a TreeNode binding error when using Data property of XmlDataSource
control. When I switch to TextFile property and point to xml file on hard
drive, problem goes anyway. I'm initializing Data property with xml string
that matches file exactly. Seems to be problem with binding because if I
remove bindings, tree works both ways. I'm binding on server like so...
TreeNodeBinding bind = new TreeNodeBinding();
bind.DataMember =...
|
by: =?Utf-8?B?TG93bGFuZGVy?= |
last post by:
Hello,
I've built a web application that uses client script callbacks. It is used
on a large network with a large variety of user OSes and IE versions. It was
tested on IE 6 on different setups and IE 5.5 to a lesser degree without
problems.
I know of a least one user who gets an error in WebResource.axd when using
the application. The same error also occurs on a simple reproduction page
with just a button and a div. When the button...
| | |
by: Mac Campbell |
last post by:
When automating e-mail messages from Access 2003 using DoCmd.SendObject, I get an Outlook warning message "A program is trying to automatically send e-mail on your behalf. Do you want to allow this?". Outlook then waits for a response. Since I want the message to be sent out from an unattended applicaton when certain conditions are met, is there a way to supress or bypass this message?
|
by: msnews.microsoft.com |
last post by:
Our IT team relocated our application servers yesterday. They had to take
one machine out of the cluster because it would prompt users for credentials
if accessed using the IP address, which I guess is what happens when it is
accessed through the firewall. However, it works as expected when I use the
machine name in place of the IP address.
To summarize, the application servers were moved to a new hosting site and
one machine is...
|
by: svsenthilkumar |
last post by:
Hai,
I got an javascript error when using ajax in mozilla browser, anyone help me why the error is coming, meaning for this error and how can i rectify this error.
Error: " nsresult: "0x80040111 (NS_ERROR_NOT_AVAILABLE)" location: "JS frame :: (here url)
|
by: iBasho |
last post by:
Hi,
I am trying to set up a notification email that would come to my email everytime users click on a command button in a form. I am using the DoCmd.SendObject command without actually sending any database objects.
Private Sub Command107_Click()
On Error GoTo Err_Command107_Click
DoCmd.SendObject acSendNoObject, , , "email@email.com", , , "Test", "Email Test", , True
Exit_Command107_Click:
Exit Sub
|
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: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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: 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...
| |
