Hi Guys,

I have a userform that is filled in by our QA agents. Once they have
completed the form, I would like the form and its results to be emailed to
the sales agent that was just assessed?

Any help?

Thanks
Albert

You cannot email a UserForm and its contents. You can send a email with the
values from the UserForm or a worksheet attached in which a "form" is
displayed.


--

Regards,
Nigel




"Albert" wrote in message
...
Hi Guys,

I have a userform that is filled in by our QA agents. Once they have
completed the form, I would like the form and its results to be emailed to
the sales agent that was just assessed?

Any help?

Thanks
Albert

Hi Nigel,

Thanks. that answers whay I have not been able to do it.

I am using an excel file as a datasheet so it will be impossible to send the
sheet as it will make no sense.

Is there a way I can embed the values in a email envelope?

If so do you have any idea how to code that?

If you have any other ideas, please let me know?

Thanks
Albert

"Nigel" wrote:

You cannot email a UserForm and its contents. You can send a email with the
values from the UserForm or a worksheet attached in which a "form" is
displayed.


--

Regards,
Nigel




"Albert" wrote in message
...
Hi Guys,

I have a userform that is filled in by our QA agents. Once they have
completed the form, I would like the form and its results to be emailed to
the sales agent that was just assessed?

Any help?

Thanks
Albert

The methods I use are all based around Ron de Bruin expert knowledge.......

http://www.rondebruin.nl/sendmail.htm

--

Regards,
Nigel




"Albert" wrote in message
...
Hi Nigel,

Thanks. that answers whay I have not been able to do it.

I am using an excel file as a datasheet so it will be impossible to send
the
sheet as it will make no sense.

Is there a way I can embed the values in a email envelope?

If so do you have any idea how to code that?

If you have any other ideas, please let me know?

Thanks
Albert

"Nigel" wrote:

You cannot email a UserForm and its contents. You can send a email with
the
values from the UserForm or a worksheet attached in which a "form" is
displayed.


--

Regards,
Nigel




"Albert" wrote in message
...
Hi Guys,

I have a userform that is filled in by our QA agents. Once they have
completed the form, I would like the form and its results to be emailed
to
the sales agent that was just assessed?

Any help?

Thanks
Albert