Email access query with more than 65000 row as outlook attachment.

[maratonomak1]

Hi

I'm trying to email an access query with more than 65000 row as outlook attachment.
The code I'm using :

DoCmd.SendObject acSendQuery, "Query1", acSpreadsheetTypeExcel12, "me@hotmail.com", , , "Subject", "Please see attached.", True

I still get " You selected more records than can be copied onto the Clipboard"

Thanks !!

 

[GinaWhipp]

Yeah, that is not an Excel limitation it is a Clipboard limitation. Excel 2007 can handle a million rows. Anyway you can break that up?

 

[paulxmw]

do a google search How can i expand the size of the clipboard then your operating system name