Transfer Spreadsheet (1 Viewer)

[cstuckey]

Hello,

I'm running a macro and want to add a step to Export a Report to Word or Excel Format in another directory. Can I do this? I use "TransferSpreadsheet" function already but I'm requests from my clients to send them the report electonically without going through the usual step to "Publish it in Word.."

Thanks,
Chris

 

[telco25]

Chris,

I'm not exactly sure if you're trying to do this from a form or reports directly. If you are doing this from reports have you tried using SendObject? Leave the TO field blank and OUTLOOK will open prompting you for this.

If you are doing this from a form you can use a command button for emailing reports. You would then change the code to:
DoCmd.SendObject acSendReport, "YOUR REPORT'S NAME", acFormatRTF, , , , "whatever you want in the subject line", "Your message in body of email.", True
Again OUTLOOK will open and prompt you for the TO, etc.
Hope this helped.

WKB