Send email for current record on form

[josros60]

how can i create a vba code to send email to current record in the form with body message and cc as well.

is there any sample code to start with?


thanks

 

[pbaldy]

Look at SendObject, either in VBA code or a macro. It would let you put a form reference in the "To" (or other) argument.

 

[josros60]

Thanks. But I am new on VBA so any sample code, please.

 

[pbaldy]

DoCmd.SendObject acSendNoObject, , , Me.TextboxName, , , "Subject", "Body", True