Export to Excel, then Outlook

[ashley25]

I know how to export from acccess to excel using vba, but what I would like to do, is export my data to excel, which then creates an email in outlook ready to be sent out. Is this possible?

 

[Rx_]

Just to be clear. Is this the objective?
Create and Save As an Excel Workbook - with your data from MS Access. Then that routine is completed.
Next Procedure: Attach the newly created Excel Workbook into a automated Outlook email.

Then probably run the two procedures in a row.

Thought I remembered this back in Feb 2013. Was wondering if it would work with Excel.
http://www.access-programmers.co.uk/forums/showthread.php?t=245085&highlight=outlook+attachment+vba

We are having a 3 day Holiday here across the pond.
Would be interested to help. Let me encourage you to submit code for both Excel and Outlook.