469,898 Members | 1,574 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

SendObject, but for a spreadsheet?

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
0 1234

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by J Bunton | last post: by
2 posts views Thread by Lumpierbritches | last post: by
8 posts views Thread by Andy Kasotia | last post: by
3 posts views Thread by Fred Zuckerman | last post: by
2 posts views Thread by Andy_Khosravi | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.