Help with send a report to word

  • Thread starter Thread starter Joe Cilinceon
  • Start date Start date
J

Joe Cilinceon

What is the code to Publish a report in Word. Now I know I can do it from
the menu but need to add a button to a form to do it. The code I've tried is
show below but goes into a loop that you have to Ctrl-Alt-Del to end

DoCmd.OutputTo acReport, "rptVacantList", _
acFormatRTF, "C:\Handi\VacantList.rtf", TrueNow based on what I read
this should save the report as an RTF file then open word and load it. --

Joe Cilinceon
 
If the report works normally. Try this

DoCmd.OutputTo acReport, "rptVacantList",
"RichTextFormat(*.rtf)", "C:\Handi\VacantList.rtf", False, ""

Chris
 
Thanks Chris it was the correct at True. is was the acReport it should have
been acOutputReport
 
Back
Top