Outputting report for each individual record in a seperate Word file?

[nabeel.moeen]

Hi,

Is there a way (using VBA or otherwise) whereby I can generate a
report and export each record details in a seperate word file which
could be named by the record Identifier?

e.g.
I have a Sales Order Report. I need the report exported to seperate
Word file for each sales order (I have checked that this works for
exporting to HTML... if not possible in word I could use HTML but if
the second requirement can be met) and each word filed to be named
using the Sales Order number.

Regards,
Nabeel

 

[Guest]

Have you looked at the OutputTo method?

I don't think this method has a filter which would allow you to export a
report for a select Sales Order, so you might have to modify that report so
that it gets its SalesOrderNumber from a control on a form. Then, in the
command button that generates the report, you could open a recordset of
SalesOrderNumbers, populate the control on your form, create a filename based
on the SalesOrderNumber, then output the report. Then, move to the next
record in the recordset and do these steps over again.

 

[sora alsaad]

hi are you arbic?
help me to learn database plz