Emailing a userform with its values

[Albert]

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

 

[Nigel]

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.

 

[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]

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

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

--

Regards,
Nigel
(e-mail address removed)