Email event procedure

[Rpettis31]

Due to the character limitations of the built in Access Macro email function
I need to create a procedure but I am not familiar with Access that well
enough to do it.

Here is what I need to do.

Send an email notification message based on the contents of the form.

The email will be sent to a group listing.


[Item], has been documented with the following issue.

[IssueDescription]

The audit found: [AuditResults]

This issue has been assigned to: [Owner]


Basically the person would just select yes to send the email on the warning
box.

The items in [ ] are the controls on the form that contain the data that
needs to be displayed.

Thanks
Robert

 

[Rick A.B.]

Robert,

Look up the SendObject command that should get you started. Post back
here if you have questions. Would suggest you give a little better
discription of what you want to accomplish.

Hope that helps.

Rick

 

[Rpettis31]

I am already using the send object portion of the macro. I want to send an
email with the following message. I do not want to send an email with an
attachment.

The message text exceeds the alotment for the field so I need VB code to
open outlook to send the message.