Output to - Save a report with a name

  • Thread starter Thread starter Robert Gillard
  • Start date Start date
R

Robert Gillard

I am trying to use a macro "output to" to save a report as a rtf, but I want
each one to save as a name from an open form. I have tried various
combinations but I cannot get it to save as above

C:\my documents\work\"&[forms]![dws]![sender name]&".rtf


Any other suggestions as the above will not work


with thanks

Bob
 
Robert,

You didn't include the full ouput line you are trying, but
the following should work. Beware, I am sure that it will
wrap in the email...

DoCmd.OutputTo acOutputReport, "rptYourReport", acFormatRTF,
"C:\my documents\work\" & [Forms]![dws]![sender name] &
".rtf"

Gary Miller
 
Back
Top