Send Report as body of email (text)

[Kristoph]

Hello,

I acidentally posted this in the FORMS section. Maybe it should go here?

I am a beginner with VB, but have used Access regularly for a couple of years. I have searched through this forum as well as others and have found some excellent code (Thank you!!!). However, I have not been able to translate or find the right code for this task: Automatically send a report as text in the body of a Lotus Notes email.

Here is what I have so far:

A Form with combo boxes dependant on each other.
A Button on the same form that runs a Report. The Report is dependant on a query that looks for the last combo box selection. The button is clicked, it opens a new Lotus Notes email, Runs the Report/Query, automatically attaches the Report as a .txt file to the email, and it's good to go!! But, I'd like to force the .txt Report to be the body of the email, not an attachment.

I am using doCmd.SendObject behind the button to open the email, run the report, format to text, and attach the file. Also, I am using Lotus Notes and Access 2000.

Any advice is greatly appreciated. Thank you.

-Kristoph

 

[kjv1611]

I think you were right on, posting over in Forms. Take a look back at that one. This "report" you're talking about is not an "Access Report" which this Forum is talking about.

--

"If to err is human, then I must be some kind of human!" -Me

 

[Kristoph]

kjv1611,
Thank you, I will hope for advice there.
-Kristoph