savesAs report

[checoturco]

Hi all,

i´m trying send a report by mail as attachement.
The problem is that i have to save the report first in a directory and then in the code to send the mail it looks for the attachement in this directory.
Have somebody knows how to save the report automatically with the name of a control value?

the DoCmd.RunCommand acCmdSaveAs doesn´t let us to put a default name for the report ( i think ).

there is any way to send the report without opening the report, like in background? i already try the modal option but with this activate all my windows get restore mode ( despite i have the docmd.maximize on forms load).

tks all for your help and a merry christmas to all from Portugal

checoturco

checoturco

 

[reclusivemonkey]

Try looking at

DoCmd.SendObject

This allows you to send an Access object in a format of your choosing without having to export it and save it in a directory. You may also want to look at

DoCmd.OutputTo