how can i send email to the current customer

[gstylianou]

Hi all,



I have a form which is continuous and showing the customers information. All records (customers info) includes email address. Its possible to add a command button (on the detail of the form) in order to send email to the current customer (current record) ?

Regards

[ranman256]

have the button (put it on form header ,not on the record) to run the command..

DoCmd.SendObject acSendQuery, vQry, acFormatXLS, [emailTo], , , vSubj, vMsg

[orange]

You could. But it would be easier for readers to provide more focused info if we knew more about your set up. What is the record source of the continuous form? Who(which clients/customers) is to receive the email(s)?

[gstylianou]

Guys thank you for your response. What I ask i think is simple.


I have a list of my customers in my form (continuous form) with the customer's Name, Surname and their email address.


I wanted to have a "Yes/No" field in order to choose the customers form the list which i want to send email, and then when with a command button i need just opens Outlook and puting the email addresses in the To: so, then I could write the text i want.

Regards

[orange]

In plain English, how do you determine who should get the email?