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

  • Thread starter Thread starter Joshua
  • Start date Start date
J

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
 
Joshua said:
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
Click to expand...


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
 
Back
Top