By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,548 Members | 1,735 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,548 IT Pros & Developers. It's quick & easy.

docmd.sendobject ...sending a non-Access object

P: n/a
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
Mar 3 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Mar 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.