EmailDatabaseObject! Via Marco. Adding Field Value to Subject Line!

[cap.zadi]

Hi

I have Send email button to send a report from the current record of form.



Just interested to add some fields values along Text Line.

Analysis Report [FiledValue]!

Any Help please?

[ranman256]

Get values off the form,
the form has fields, used as parameters for the report,

sSubj = me.txtbox1
sBody = "Hello, " & txtBox2

docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo,,, sSubj, sBody

[cap.zadi]

Hi, Thanks for the feedback.

We cant add in the macro Subject line?