E-mailing Reports

[BoroLee]

I have managed to create the command to e-mail the reports. I now need to be able to e-mail them to the right people. I have the -email address in the query which the report is bound to, but i don't know what to type in the event as the To :

My query is called Q_Code List for Cost Centre's
and the field is called E-mail

Thanks.

 

[Talismanic]

BoroLee,

I am not sure if I understand your question fully or the results that you are trying to get but this may be helpful to you.

Put this behind a comand button:

DoCmd.SendObject , , , Me.txtEmail, , , "YourSubject", "YourText", True

Then just replace the Me.txtEmail with Me.YourTxtBox that holds the email address.

If you want to use a subject line, or message text from a control (text box) you can substitute: (note the absense of the quotes when you use Me.AnyThing)

"YourSubject" with Me.YourSubject (replace your subject with your text box name)

"YourText" with Me.YourText (replace your subject with your text box name)

If you only want to use the email then leave the subject and message blank, just leave the empty commas.