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.
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?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.