email, sending copies

[niteraven]

hi all

I have a form that i have a command button on to send a report thru email. The following code is outputting the email in RTF format, and all is good, except the Report it sends is an exact copy of the one report 5500 times. IE it keeps on repeating the report over and over again until it makes a 9 meg rtf file as an attachment.

DoCmd.SendObject acReport, "rptemailcustomer", acFormatRTF, email, , , emsubject, emailmemo

any ideas?
thanks
Raven

 

[lameid]

It sends one e-mail that big? If it is a bunch of e-mails, post the whole procedure.

Try using...

docmd.openreport "rptemailcustomer"

That will verify if the report is what you expect it to be.

 

[niteraven]

Thank you lameid!

I found out that i had used the table as the control source when i was adding fields, and did not make the controlsource blank afterwards. I am pulling info from a form.

Raven