Output to - Save a report with a name

[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

 

[Gary Miller]

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