E-Mail from Access

[roxannep]

Boss is asking if I can e-mail to selected customers in database. Sure ... I think!<br><br>We use Microsoft Explorer/Yahoo Mail. We have Outlook on the machines but don't use it for email. <br><br>Also, there are several different &quot;canned messages&quot; we would like to send, and we don't want each recipient to see the other recipients when we do a group e-mail (reminder notices, etc.). <br><br>Can these messages be set up with fields in a form such as Subject, message, etc., so users can choose the &quot;canned&quot; message? If so, how do I get them out to the email itself once q query selecting the recipients has run?<br><br>This is in Access 97. <br><br>Thanks for any help in advance.

 

[Guest_imported]

See the send object method in access help. This will do exactly what you want. There have been other postings in this forum if help does not give enough info for you