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

SendObject, but for a spreadsheet?

P: n/a
Another thread got me going on SendObject.

Works like a champ for emailing somebody a .SNP of a report as
in:
DoCmd.SendObject acSendReport, "rptMaturities", "Snapshot
Format", "pCresswell", , , "Maturities", "Maturities Report
attached...", False
But I do lot of so-called "reports" where I'm actually creating
an Excel workbook from scratch.

I was hoping I could point SendObject at the Excel.Application
object I was using for the workbook, but no luck - as in:

DoCmd.SendObject acSendNoObject,mySS,,"pCresswell",,,"SendObject
Test w/XLS","XLS Attached?",False

Where "mySS" in the Excel.Application object.

Is there any hope for SendObject here, or do I need to go to some
sort of eMail API?
--
PeteCresswell
Feb 5 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.