button to send email from form

[adityatandel]

I have a text box in a form and button below that. is there a way, where an email is sent with the information in the text box once the user clicks on the button?

Thanks

[alansidman]

Create a Macro. Use the SendObject Action. Complete the arguments at the bottom. ie. Object Type: Query, Report, Form, Table, etc.
Object Name: Whatever you have named it
Object Format: The form you wish to have for the attachment, HTML, Excel, etc.
To: Enter the email address and if more than one separate them with semicolons (
CC: Same
BC: Same
The rest is intuitive. Save, name, etc.

In your Form you have created a button to fire off the email. Right click on it to bring up the properties. On the event tab, select the On Click command and move to the right and select the drop down. Select the macro name you created above.

HTH

Alan

[adityatandel]

Thanks a lot man!

Is there a way, I can include the info in the text box in the body of the email and not as an attachment?

[alansidman]

Leave the object name blank
Leave the object format blank

In the message text box: Type =[Forms]![YourFormName].[YourFieldName]

Make sure that the record you wish to send is the current open record in your open form.

Alan

[adityatandel]

That worked. Thanks!

[PCRIDE]

On this note, how would I populate the TO line from an email address in a table? I have built a form and can email it, but I want it to email the users name from the report I have pulled for that person.

[cuchuflito]

i have a similar issue i hope someone may help me
i created a table and a form. the form basically shows the contents of the table, right. well one of the text boxes shows the contacts email. i would like to know how could i do to create a button which if i pressed it would pick up all the emails from all the contacts and send them an email.
for example for Christmas i would like to send an email to all my contacts. so the button should add all the emails to a b cc in Thunderbird and so then i am able to right whatever i want and send them the emails.

thanks a mil

[alansidman]

I looked around and found this. It was designed for earlier versions of Access, but it might get you to where you need to be with a little bit of VBA changes.

http://www.rogersaccesslibrary.com/f...ts.asp?TID=352

Alan

[PCRIDE]

I was able to get this working using a single email address.

However usiong mulitple emails I am not sure unless the emails were in a single fieild

[alansidman]

Look at item 106 here

http://www.helenfeddema.com/access.htm

Alan