sending Email via Outlook

[Guest]

Hello All,

I need some help automatically sending email out using a command button.

Scenario:

I have to send out confirmation on attendees for a meeting.

Table structure:

Name
Email Address
Attending
No of Guests
No of Children

I want to be able to automatically create an email that will send to each
individual record that will indicate whether or not they are attending, how
many total guests and how many children. Also, if possible is there a way to
create the outlook message to have voting buttons so the recipients can just
click on "confirm" or "edited" to send the response back to me?

I would appreciate any help I can get with this.

Thanks,
Jessie

 

[Guest]

One method:

Dim SendTo As String ,MySubject As String, MyMessage As String
SendTo="(e-mail address removed)"
MySubject = "Title"
MyMessage = Me.Field1Name & " " & Me.Field2Name
Docmd.SendObject acSendNoObject,,,SendTo,,,MySubject,MyMessage