Sending multiple reports via outlook (2 Viewers)

Mr. Southern

Registered User.
Local time
Today, 07:04
Joined
Aug 29, 2019
Messages
90
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

I’m here to help
Staff member
Local time
Today, 05:04
Joined
Oct 29, 2018
Messages
21,357
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.
 

Users who are viewing this thread

Top Bottom