Email event procedure

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

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
 
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
 
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.
 
Back
Top