Sending multiple reports via outlook

[theDBguy]

The query that I use to create the report.

And what's different between that and the non-working query? Can you post both SQL statements for a comparison?

 

[Mr. Southern]

And what's different between that and the non-working query? Can you post both SQL statements for a comparison?

With DoCmd.TransferSpreadsheet can you only use queries and tables? I was trying to run it off my report.

 

[theDBguy]

With DoCmd.TransferSpreadsheet can you only use queries and tables? I was trying to run it off my report.

Hi. Yes, according to this MS documentation, that's correct. Here's a quote from it:

TableName Optional Variant

A string expression that is the name of the Office Access table that you want to import spreadsheet data into, export spreadsheet data from, or link spreadsheet data to, or the Access select query whose results you want to export to a spreadsheet.