Access 2010 VBA Export Current Filtered Recordset to Excel

[tomdudas]

I want to take the current, filtered recordset from my Access 2010 form and export it to Excel for a Word mail-merge.

but the TransferSpreadsheet OR docmd.output commands required a fixed table or query???


DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
"tablename", "e:\Access2010\tmpCCdeclined.xls", True

 

[SkipVought]

Hi,

Why, "export it to Excel for a Word mail-merge?"

Why not use the query you are using in MS Access as the data source for your mail merge?


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}