Export separate snapshots

[jhicsupt]

I have a table with the managers names and email addresses. I would like to
send an email to each manager of their respective reports. I would like a
separate snapshot for each manager of their accounts.

I have one report based off of a query and five managers.

Table name: Mgrtbl
Report name: Inventoryrpt

Is there a code that I can use to tell Access to export the snapshot for the
various managers to my local drive?

PS - I'm not good with code, but can copy and paste

Thanks in advance.

 

[Ken Snell [MVP]]

Probably not exactly what you seek, but I have code here that lets you
export data to separate EXCEL workbook files for your situation:

Create a Query and Export multiple "filtered" versions of a Query (based on
data in another table) to separate EXCEL files via TransferSpreadsheet (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#FilterExportSepFiles