Access: Saved Exports

[gheyman]

I exported data to excel and while doing so it asked me if I wanted to save the steps, which I did. I would like to add a button to a report to run that saved export. Is there a way to do that? There are many users and a button on a form is easier than trying to teach everyone to use the Ribbon.

 

[stumac]

The following command runs the saved export:

DoCmd.RunSavedImportExport "[I][COLOR=#b22222]ExportName[/COLOR][/I]"

This will overwrite the file every time it is run so if you want save it with a dynamic name (i.e. adding the date to the filename) then consider using DoCmd.TransferSpreadsheet

 

[gheyman]

Thank You. What if I wanted to send a query results, in excel, as an attachment in outlook. Is that possible?

 

[stumac]

There is a few ways, the easiest, would be to create a macro and select the send database object action.


this can be done via vba too:

https://docs.microsoft.com/en-us/office/vba/api/Access.DoCmd.SendObject

It isn't very user friendly because if you want to send it without user input then they get a warning popping up with a short timer before they have to hit send. If the edit argument is true then they can edit and send it ok. another way (avoiding the pop up) is to save the query, then use vba to create a new email and attach the file and send. there is an example here that would just require you to add in the code to save the file (as per previous code) then attach it (oMail.Attachments.Add "FileName") before its sent.