Emailing info from a form

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

Hi,

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

Thanks
Linda
 
Are you looking to get a list of multiple reference numbers or just email 1
reference number?
 
The simplest way would be to do something like this:

Dim msgString as String
msgString = Me![Reference Number Field]
DoCmd.SendObject , , , "(e-mail address removed)", , , "The reference number is " &
msgString & "."
 
It would be one reference #. I'm creating a databse where the users fill out
info for a report request. Everytime there is a new request, it will
generate a new ref #. When the user is done filling out the form then they
need to click on Email request but i only want the ref # from the form.

Thanks
Linda
 
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 said:
The simplest way would be to do something like this:

Dim msgString as String
msgString = Me![Reference Number Field]
DoCmd.SendObject , , , "(e-mail address removed)", , , "The reference number is " &
msgString & "."

Dustin B said:
Are you looking to get a list of multiple reference numbers or just email 1
reference number?
Click to expand...
Click to expand...
 
Back
Top