How do I attach an email to a form response

[CAQ]

I have been developing a customer survey for my company and have hit a brick
wall. I can not seem to get the vb code correct on the email macro -- here
is what I need the macro to do:

User fills in form
user clicks the check box to submit survey responses
form saves
form sends the email responses to me
subject line = survey response
msg box pops up stating - your responses have been submitted.
Thank you
form closes

Any ideas?

 

[Robert M. Franz (RMF)]

Hi CAQ

I have been developing a customer survey for my company and have hit a brick
wall. I can not seem to get the vb code correct on the email macro -- here
is what I need the macro to do:

User fills in form
user clicks the check box to submit survey responses
form saves
form sends the email responses to me
subject line = survey response
msg box pops up stating - your responses have been submitted.
Thank you
form closes

Any ideas?

better post these in one of the vba related forums, and include any code
you have so far.

HTH
Robert