E-mailing from Access form

[tarynnl]

i have created a database which will be used to add records of peoples information. for each records is a field called Emailaddress. I need to be able to create a button so that when its clicked on, it takes the e-mail address for that record and puts it into the To: option and allows me to send that record information back to the person as a confirmation... i have tried many different options e.g. sendobject macro but they are not working out too well.. anyone can help pleeeease

 

[Kevin_S]

don't use a marco - they are awful - you need to use a recordset/array and loop through the records populating the set and firing emails. Search the forum for "email" as this has been covered alot!

HTH,
Kev

 

[tarynnl]

thanks but i have been on many a site and search thru many forums and i seems to come up with much the same coding but none seem to do what i need... is it actually possible?

 

[sdebo2]

Just do a search in Access help for “SendObject”. Put[FieldName] where you want to pull information from a field in the form. I put the below in the OnClick event of a button in one of my databases to send and email. Note mine sends an email to [USERID] & "@Hotmail.com”, [USERID] only store the beginning the email address, so I had to add the @Hotmail.com part in the code. StDocName is a variable that set before this code and is the name of the Report that is emailed.

Code:
DoCmd.SendObject acReport, stDocName, "RichTextFormat(*.rtf)", [USERID] & "@Hotmail.com”, "", "", "Weekly Update for " & [FullName], "Attached are the projects that " & [FullName] & " Recently worked on", True, ""