Generate and send email using macro after user enters data in a subform

[razor7132]

Hi All,

I have six users who are dependent on each other's work in a hierarchical manner. For example: Person A does work that feeds info to Person B that feeds info to Person 3 ... Person 6.

Where do I even start to generate and send an email using a macro after a user enters data into a datasheet sub form?

I have no VBA experience.

Thanks.

 

[David R]

Google is your friend: http://msdn.microsoft.com/en-us/library/office/ff196780.aspx

If that doesn't work, you'll have to be specific about what you tried and what didn't work, and HOW it failed (error messages, etc).