exporting to excel errors out

J

James

Hi, how can i export a query from access 97 to a file that is easily
importable by outlook? when i use:
'DoCmd.TransferSpreadsheet acExport, 8, gstDocName,
"c:\2ndstep\EmailList.xls", True
i get the error: "Couldn't find installable ISAM" when exporting from access
97
when it i use:
DoCmd.OutputTo acOutputQuery, gstDocName, acFormatXLS,
"c:\2ndstep\EmailList.xls", False
i get the error: "emaillist.xls has no named ranges" when importing into
outlook
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Report with Graph to Excel error 2495 1
VBA - exporting serial letters to single documents 0
Export to spreadsheet error, help please 2
Export spreadsheet method in 2007 Access 6
Export Access queries to excel 1
Converting isse with Export in Outlook 0
Delete old information when transferring to excel 6
personal excel macro causing access not to open excel file 0

Top