RE: Emailing info from a form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



What if all the data from a form needs to be emailed to a certain email
address? How would the code look for that? Thank you.

"Nicholas Scarpinato" wrote:

The simplest way would be to do something like this:

Dim msgString as String
msgString = Me![Reference Number Field]
DoCmd.SendObject , , , "email@xxxxxxxxxxx", , , "The reference number is " &
msgString & "."

"Dustin B" wrote:

Are you looking to get a list of multiple reference numbers or just email 1
reference number?

"Linda" wrote:

Hi,

I need to email a reference # from a form. I just need the ref #. Is there
anyway to do this?

Thanks
Linda
.