E-mailing a report to indicated user

[smoker1]

Is there a way to e-mail a report (using Outlook 2000) to the person who filled out a form, as well as to a distribution list? I currently am using a Macro to SendObject to the distribution list, but am confused how to e-mail a copy to the user as well.

For example, if Sally Jones filled out the form, she should get a copy of the e-mailed summary report that is sent out to a distribution list.

Is this possible? Thanks for your assistance!

smoker1

P.S. The report does have a field that has the agent's email address.

 

[crose7227]

use that field and jsut distribute it (sendobject) again land of milk and Honey

 

[smoker1]

That is definitely what I want to do, but how do I fill the "to" section with a dynamic field name?

 

[crose7227]

create a global variable (in a module) and then assign it the fields value, then put that variable into the criteria of the sendobject land of milk and Honey

 

[smoker1]

Unfortunately, the code I'm using isn't working.

I simply created a command button that works on the following code:

DoCmd.SendObject acReport, "Witness Dispute Form", acFormatRTF, "[E-mail]; CSC TLs (Reports)", , , "Current Witness Disputes", , False

I haven't had to work with many VB strings (as I generally work in Java & JavaScript), and am not sure what I am missing. The field name that contains the e-mail address of the user is named e-mail.

Can you provide me with a little more detail, crose7227? Thank you!

 

[crose7227]

change this

"[E-mail]; CSC TLs (Reports)"...

to this

tablename.[E-mail] & ";CSC TLs (Reports)"

and when you say ur code isn't working what kind of error do you get?


or it just doesn't send? land of milk and Honey

 

[smoker1]

I am receiving a run-time error '2295'. Unknown message recipient(s). Message not sent.

This is my code:
DoCmd.SendObject acReport, "Witness Dispute Report", acFormatRTF, "tblAgents.Agent E-mail Address" & "; CSC TLs (Reports)", , , "Current Witness Disputes", , False


Thanks.