Email an .xls on the C:\ from an Access form in VBA

[Joshua]

Hello,

Does anyone know how I can email an Excel spreadsheet on
the C:\ from a form in Access? The .sendobject only sends
objects that are in the Database.

Thanks,
Joshua

 

[Matt]

Hello,

Does anyone know how I can email an Excel spreadsheet on
the C:\ from a form in Access? The .sendobject only sends
objects that are in the Database.

Thanks,
Joshua

I don't think you can e-mail directly from Access. Have you tried
doing something like a mail merge? You can attach the spreadsheet to
an e-mail message and set up a command button to trigger the e-mail in
Outlook.
The following is a page by Arvin Meyer that describes how to create
mail messages from Access:
http://www.datastrat.com/Code/OutlookEmail.txt

Hope this helps,
Matt