Output to Outlook express problems

R

Randy

I'm trying to output a query to outlook express for e-mailing. I need the
ability to name the excel file at will prior to e-mail. I've been trying,
by creating an unbound form with a textbox to enter the file name, then
clicking on a button to run a macro. With the intention of outlook express
popping up with the named file attached. In the macro I have: Transfer
type: Export. Spreadsheet Type: Excel8-9. Table name: Summary Export
(Query). File Name: =[Forms]![EMailSummary]![SummaryFileName] & ".xls"
Has Field names: Yes
I just cannot get it to work...Any Ideas...Thanks...Randy
 
S

Steve Schapel

Randy,

To get a query attached to an email, you need to use a SendObject macro
action, whereas the aerguments you have mentioned are more reminiscent
of a TransferSpreadsheet action.
 

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

Output to : Template file 3
2007 runtime errors "output to" not available SendObject fails 2
output to text 3
Output to - pop up message 2
Export table to txt file with a variable filename 0
Output To text with no headers ? 3
Need to export multiple files 3
output file name - errors 3

Top