Output to Outlook express problems

  • Thread starter Thread starter Randy
  • Start date Start date
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
 
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.
 
Back
Top