Send report with subforms via email (.rtf) ?

[Paul Kraemer]

Hi,

The company I work for uses an Access 2003 application that I am familiar
with but I did not create myself. We find it useful to be able to email
copies of certain reports to customers. Currently, we are able to do this
for most reports by opening the report in Print Preview mode. We then
right-click on the previewed report and choose Send To => Mail Recipient and
choose "RTF" as our desired format. This works great except for one
particular report. I believe the problem with this one particular report is
that it makes use of two SubForms. When we try to send this report to a mail
recipient as an .RTF, we get a message saying that the "Save As comand can't
process subforms contained in your report - do you want to proceed anyway?".
If we say yes to proceed, the information that would normally appear in the
SubForm is missing in the .RTF that is generated.

I was wondering if there is any easy way to get around this limitation other
than recreating the report in a way that does not use subforms.

Any advice will be greatly appreciated.

Thanks in advance,
Paul

 

[Rick Brandt]

Hi,

The company I work for uses an Access 2003 application that I am familiar
with but I did not create myself. We find it useful to be able to email
copies of certain reports to customers. Currently, we are able to do this
for most reports by opening the report in Print Preview mode. We then
right-click on the previewed report and choose Send To => Mail Recipient
and
choose "RTF" as our desired format. This works great except for one
particular report. I believe the problem with this one particular report
is
that it makes use of two SubForms. When we try to send this report to a
mail recipient as an .RTF, we get a message saying that the "Save As
comand can't process subforms contained in your report - do you want to
proceed anyway?". If we say yes to proceed, the information that would
normally appear in the SubForm is missing in the .RTF that is generated.

I was wondering if there is any easy way to get around this limitation
other than recreating the report in a way that does not use subforms.

Any advice will be greatly appreciated.

Your report is using a sub-FORM instead of a sub-REPORT. The former works,
except for the problem you are experiencing.

If you change the sub-form to a real sub-report then it should work.