VBA code - From Access , Export query results into excel, then Email

[Hacktastic]

Hi

I have most of this automated so I just need the sniplets of code.

1) code that runs a particular query and exports it in excel
2) code that then attaches that excel spreadsheet into a outlook email.

Has anyone done this before?

 

[PHV]

And what have you tried so far ?
Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[xlbo]

Both items have been covered in this forum. There are FAQs on controlling outlook from other office apps. Try searching the forum and looking at the FAQs

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Hacktastic]

Thanks guys