I collect information from my clients with an xls file
I import the xls data into my access table.
I don't have them put info directly into Access, because, despite the
drop downs I have for data validation in my xls sheet, some fields are
not suited to drops downs and there is some editing I have to do.
Its not a big deal, I do this maybe 20 times a week.
So on a tab in my form, I have a make request button which I want them
to be able to dblclick it, send the xls sheet to me, be able to edit
the xls sheet, and then send it off.
I see how to send access objects with sendobject, but I have been
unable to figure out how the syntax to send non access objects in the
way I described.
This is what works for me now
Private Sub cmdSendEMAIL_Click()
DoCmd.SendObject acSendNoObject, "", "", "je*********@pioneer.com",
"", "", "", "", True, ""
End Sub
None of those "" switches are to identify attachments or external
files that I can determine.
This works to send me an email, but how to I get it to attach an xls
file?
Thanks
Jerry 1 3874 je*********@pioneer.com wrote: I collect information from my clients with an xls file I import the xls data into my access table.
I don't have them put info directly into Access, because, despite the drop downs I have for data validation in my xls sheet, some fields are not suited to drops downs and there is some editing I have to do. Its not a big deal, I do this maybe 20 times a week.
So on a tab in my form, I have a make request button which I want them to be able to dblclick it, send the xls sheet to me, be able to edit the xls sheet, and then send it off.
I see how to send access objects with sendobject, but I have been unable to figure out how the syntax to send non access objects in the way I described.
This is what works for me now Private Sub cmdSendEMAIL_Click() DoCmd.SendObject acSendNoObject, "", "", "je*********@pioneer.com", "", "", "", "", True, "" End Sub
None of those "" switches are to identify attachments or external files that I can determine.
This works to send me an email, but how to I get it to attach an xls file?
Thanks Jerry
I guess you'd want to send a query or table and use the Excel format.
Nnot tested...Perhaps you could set up a temporary link to the Excel
file and then send the table/query. Perhaps if it's a linked table you
may have to use a query.
SendObject does NOT send non-Access type files; Word, Excel, or anyother
type of file you'd want to send as an attachment. Why? Who knows. I
guess MS decided nobody would ever want to send email attachments.
If you google at google groups you'll find code to send attachments via
Outlook.
Also check out Tony's site at http://www.granite.ab.ca/access/email.htm. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jay Bienvenu |
last post by:
I am trying to execute a DoCmd.SendObject command to produce an email
message from Access 2000. The command produces the email message, but
the To:, CC: and BCC: fields are blank. The subject field...
|
by: Lauren Quantrell |
last post by:
I get the prompt from Outlook Express when trying to send an e-mail
using DoCmd.SendObject in MS Access2000:
"A program is attempting to send the following e-mail message on your
behalf:"
To:...
|
by: Fred |
last post by:
I want to insert DHL and FedEx tracking links with the waybill numbers in
the body of emails I am sending using sendobject. I am not sending
attachments. DHL and FedEx use long links that...
|
by: Lauren Quantrell |
last post by:
This works in my Access2000 MDB but not in the MDE created from the
same file (on the same workstation):
DoCmd.SendObject acSendReport, "myReportName", acFormatRTF,
"someone@somewhere.com", , ,...
|
by: Rob |
last post by:
I am trying to send an e-mail by clicking a command button using
DoCmd.SendObject acSendNoObject. I would like to insert a hyperlink in
the message of the email, but the problem is the file path...
|
by: dszmauz |
last post by:
I'd like to send a report to a distribution of email addresses. The distribution list is stored in Email.. How do I use the DoCmd.SendObject to send to a list? The command below isn't working:...
|
by: Bgreer5050 |
last post by:
When I send the report below "OpenPOsQueryReport" it is sent as an
attachment. Is there a way to have it sent in the message body?
Thanks
Private Sub Report_Page()
On Error GoTo...
|
by: Filips Benoit |
last post by:
Dear All,
DoCmd.SendObject acSendReport, "RPT_ITEM", acFormatTXT,
Me.CNT_EMAIL, , , "testEmail", "test", False
The report is converted to RPT_ITEM.txt before sending as attachment.
Is the...
|
by: neosam |
last post by:
Hey all,
I am not able to integrate these 2 actions in one command. What i am doing is...
A button which sends a report with only specific data to a particular person (via outlook). I am able to...
|
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...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
|
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,...
| |