Sending Email From Access

E

Emma Hope

Hi All,

I have my database opening and closing an Excel spreadsheet, the Excel
spreadsheet automatically refreshes on opening and is then saved with a
different name on closing. All good so far.

Now i want my database to have a button where it opens an email, attaches
the right filename and allows the email to be edited before sending.

I know you can use 'sendobject' to send data directly from the database to
the email but this needs to be attaching an external spreadsheet.

Alternatively, is there a way of perhaps having the Excel spreadsheet, on
closing, knowing that it is to attach itself to an email?

Thanks
Emma
 
Top