email blank report

[JethroUK©]

I have a report that complies weekly statistics - painfully populated by VB
from the Activate event

This report works fine when run - but when emailed from a form via:

DoCmd.SendObject acSendReport, stDocName, acFormatRTF

the report that is attached to the email is blank ? (unpopulated)

Any clues (i've tried populating the report in Report.Open event)

 

[Arvin Meyer [MVP]]

Did you try to export then open the rtf file and make sure the data is
there? It may not be an email problem at all. If it is an email problem, and
you are using Outlook, the following code will allow you to send an
attachment after it is created and saved:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access