Terry,

It sounds you really need Crystal Reports, which can create really complex formatted reports and sends the output in the the desired format(Word, Excel, RTF, AscII etc) trough E-mail. CR intergrates fine withing VFP, though there are some difficulties to overwin.