Send email from form

[hwmueller]

Hi

I am wanting to give a user the option to email himself the results of his selection. The user fills in a form by means of checkboxes. Following this a message box asks if the user wants to email the selection to an email address of choice. If the user says yes, then a form pops up which has an unbound text box in which the user can enter his email address. A click button should then send the email off. How do I do this????

Thanks

Hans

 

[Iainn]

It depends which email program you are using. We currently use Netscape and Access doesnt have a netscape library so have to use the MAPI configuration. This means that I have to use the SendObject command, filling in the 'To' and 'Message' boxes with the controls from a form, such as [Forms]![yourformname]![yourcontrol]. The only problem with this is that you can only use 255 characters in the message, so you may have to create a report based on the information the user selectes and attach it to the email message using 'OnjectType' = Report, 'ObjectName' = "YourReportName". If you are using Outlook however it is much more configurable and there is plenty help on the the Microsoft Website for the code and so on you require.

Regards.

IainN.