Email message text

  • Thread starter Thread starter theresa_fec
  • Start date Start date
T

theresa_fec

I am trying to code my Message Text to accept the view of the Form I am
working and email it as body. How do I code this? I am having issues
understanding the "DbLookup", "(etc.)"

Thanks Theresa
(e-mail address removed)
 
Hi Theresa
I would send a report rather than the form. It should be relatively simple
to translate the information onto a report. You can then use something like
this.
DoCmd.SendObject acSendReport, "rptThisScreen", "Snapshot Format(*.snp)",
"(e-mail address removed)", , , "Email Header", "Hi John. This is the report", "False"
 
theresa_fec said:
I am trying to code my Message Text to accept the view of the Form I am
working and email it as body. How do I code this? I am having issues
understanding the "DbLookup", "(etc.)"
Click to expand...

No need to use DLookup if all the data is on the form.

strBody = "Some text here" & vbcrlf & _
me.CustomerName & vbclrf & _
"Some more text."

You can use the me. to get the data values from the form and stuff
into a string variable.

Tony
 
Back
Top