Button for sending a specific row of information to a specific email adress

[KristianFriis]

Hi,

I am trying to figure out how to make a button that sends an email to a specific email address, containing the information from 1 row.

the idea is this:


we have rows where we put the the address, the quantity and the time interval we can collect the packages in. these information have to be send to a trucking company.
I want access to send an email to the trucking company's email address, and not a whole report of all the rows, but be able to choose to send row 1,2,3 etc.

is this possible?

[ranman256]

on my form, I have a list box (or combo) of email addresses to pick,
user selects a record in the form ,
now you have the record ID, txtID box and the email, cboEmail
you have a query that reads the txtID to pull the 1 record, "qs1Rec", this query reads the txtID on the form as parameter
now send it with the button click:

sub btnSend_click()
   DoCmd.SendObject acSendQuery, "qs1Rec", acFormatXLS, cboEmail, , , "Subject", "message"
end sub