mail out data ?

[behedwin]

Hi

Is it possible to setup a function that works like this.

1. User opens a form
2. User select a receiver from a combobox
3. User press a button and a mail is sent to the receiver containing some data.

Table with receiver: User_Table
Column of data to be sent to receiver is stored in User_Table in column "info_send"

Mail to be sent should contain some text and then the "info_send" information.


Is this possible?
How do i setup a outgoing mail like this and make a template for an mail to be sent?
And make sure that only the row of the receiver information is sent.
So if the user select "Johan" in the combobox, a mail should go to johans mailadress (stored in User_Table) and mail should contain Johans records of column "info_send".

Hope this makes sense.

 

[Micron]

Very possible. There are a gazillion web pages on how to do this. Try this one
If you encounter security type barriers, there are other options such as Automation (controlling Outlook from Access, which obviously the user must have) or using COM programming (more difficult).